Post reply

Date Conversion

  • February 27, 2013 at 5:36 am

    #290038

    Hi all

    I have a date which is in a text file which looks like this '25/02/12 11:39:34'

    I have been playing around with CONVERT so I can insert it into a DATETIME field of a database but I keep getting conversion errors.

    Does anyone have any suggestions on how I can do this?

    Thanks

  • February 27, 2013 at 5:42 am

    #1591505

    SET DATEFORMAT DMY

    SELECT CONVERT(datetime, '25/02/12 11:39:34')

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • February 27, 2013 at 7:37 am

    #1591554

    Oh right - thanks very much 🙂

  • February 27, 2013 at 8:30 am

    #1591583

    This would work as well:

    SELECT CONVERT(datetime, '25/02/12 11:39:34', 3)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply