hatbrox
02-12-02, 16:42
| hello, 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, Matthew |