Home Forums SQL Server 2008 T-SQL (SS2K8) Convert Text to Date DataType RE: Convert Text to Date DataType

  • August 14, 2012 at 12:04 pm

    #1525712

    santa326 (8/14/2012)

    Hi Mark,

    yes i can do that but,how will sql know that my text is in dd/mm/yyyy for and not in mm/dd/yyyy or smthing else.

    regards

    Ravi T

    The third value in the convert statement tells SQL Server the string value of the data/time is in dd/mm/yyyy format.

    For more information, read this:

    http://msdn.microsoft.com/en-us/library/ms187928.aspx