Home Forums SQL Server 2008 SQL Server 2008 - General date format 7/31/2013 RE: date format 7/31/2013

  • March 4, 2013 at 12:16 pm

    #1593128

    declare @dt datetime

    set @dt = '2013-03-01 18:40:24.000'

    select convert(varchar(10), @dt, 101 )