none
Date Conversion Help

    Question

  • Hi Guys,

    My input data is STRING in this format and the column name is [Column 1]

    Input Data

    31/03/2009 6:07:00 PM

    Output Data Required

    2009-03-31 6:07:00 PM

     

    I need a expression to convert it, any help much appreciated.

     

    Thanks in Advance,

    D


    Wednesday, October 06, 2010 10:05 PM

Answers

  • SUBSTRING( Column1 , 7, 4 )  + "-" + SUBSTRING( Column1 , 4, 2 )  + "-" + SUBSTRING( Column1, 1, 2 )  + " " + TRIM(RIGHT(Column1,11))
    Nitesh Rai- Please mark the post as answered if it answers your question
    • Marked as answer by ozsql Thursday, October 07, 2010 2:27 AM
    Thursday, October 07, 2010 1:08 AM

All replies