Post reply

how to convert varchar to datetime

  • February 10, 2010 at 9:56 am

    #219090

    Hi ,

    i have a varchar column 22-nov-09 i want to conert into datetime datatype with 02:15:00 millisec...

    It should be 2009-11-22 02:15:00..

    can anyone help me?

  • February 10, 2010 at 10:02 am

    #1116974

    Lookup CONVERT in Books Online. That is the best place to start to answer your question.

  • February 10, 2010 at 4:34 pm

    #1117279

    You could also look on Lynns blog. He has some examples there of various datetime operations.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 16, 2010 at 1:59 pm

    #1119537

    I have looked every where for this,

    I want datetime to convert into varchar (ex:16-feb-10)

    but i found convert(varchar, columnname , 6) which is converting into 16 feb 10..

    can anyone help?

  • February 16, 2010 at 2:11 pm

    #1119551

    replace(convert(varchar, columnname , 6),' ','-')

    Does this help?

  • February 16, 2010 at 2:23 pm

    #1119564

    Yes it helped ,Thank you

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

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