Results 1 to 2 of 2

Thread: converting time

  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Unanswered: converting time

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    5
    Actually convert(datetime, '01/15/2002 04:17:05 PM', 101) works fine.
    Check out the locales settings of your server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •