Post reply

Converting string to datetime format

  • April 23, 2009 at 8:03 am

    #203863

    Hi,

    I´m hoping somebody can help with this. I need to convert a set of dates (in string format) to the datetime data type.

    The data is currently stored as strtings in the following format:

    [font="Courier New"]

    Monday, January 28, 2008[/font]

    Thanks in advance

  • April 23, 2009 at 8:38 am

    #982962

    Try this:

    declare @testdate varchar(50), @realdate datetime

    set @testdate = 'Monday, January 28, 2008'

    set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)

    select @testdate, @realdate

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • April 23, 2009 at 8:43 am

    #982970

    Please don't double-post in multiple forums.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • April 23, 2009 at 8:47 am

    #982975

    Ahh, didn't consider double-posting. I thought that I had posted that reply, but then I second-guessed myself and figured that I just didn't click the post button...

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • April 23, 2009 at 9:03 am

    #982997

    Sorry, wasn't aiming that comment at you, Wayne. Was meant for the OP.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • April 24, 2009 at 4:44 am

    #983451

    Hi GSquared,

    I did try to delete my first post so as not to double post, but it wouldn´t let me.

    Cheers

    David

Viewing 6 posts - 1 through 5 (of 5 total)

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