bash - Parsing text file to variables -
$ cat file.txt example1@domain1-username i'd parse file.txt , export contents variables like:
var1=example1@domain1 var2=username
var1=$(cut -d "-" -f 1 file.txt) var2=$(cut -d "-" -f 2 file.txt) sql - Time in datatime field -
i have field stores date , time need extract shows time shows date 01/01/1900 . i can extract time using below need include data of 01/01/1900 convert(varchar(12), w.created, 114) if using sql server, can do: select cast('1900-01-01' datetime) + cast(cast(w.created time) datetime) this returns value datetime . sql server has time data type. unclear why want add in fake date, can.
Comments
Post a Comment