Post reply

Converting strings to datetime

  • April 23, 2009 at 8:08 am

    #133313

    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:41 am

    #982968

    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 9:09 am

    #983006

    Hi Wayne,

    Cheers for that. Much appreciated. It´s saved me a couple of hours work (I´m new to T-SQL).

    David

  • April 23, 2009 at 9:48 am

    #983047

    I seem to be doing lots of date related stuff at the moment, luckily nothing involving dates in such a format, however, I'm sure a time will come - this looks very useful!

    Thanks!

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

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