Home Forums Programming General altering column from datetime to varchar eliminates seconds and milliseconds part RE: altering column from datetime to varchar eliminates seconds and milliseconds part

  • January 19, 2005 at 2:03 am

    #537997

    or you could use this:

    select convert(varchar(12),getdate()) + right(convert(varchar,getdate(),126),len(convert(varchar,getdate(),126))-charindex('T',convert(varchar,getdate(),126)))

    result = Jan 19 2005 08:48:19.397

    depending on your preferencing for displaying the date to your users.

     

     

    regards,

    Mark Baekdal

    http://www.dbghost.com

    +44 (0)208 241 1762

    Database change management for SQL Server