var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: converting time
I'm struggling import a flat file with one column containing the following the value:
'10/15/2001 04:17:05 PM' (single quotes are also in the text file)
I know that using:
convert(datetime, '01/15/2002', 101) works fine but what would the syntax to transform the 04:17:05 PM into a suitable value.
Any help is greatly appreciated,
Actually convert(datetime, '01/15/2002 04:17:05 PM', 101) works fine.
Check out the locales settings of your server.