Home Forums SQL Server 2005 T-SQL (SS2K5) Converting Getdate() To Varchar RE: Converting Getdate() To Varchar

  • February 6, 2008 at 10:09 am

    #775699

    SELECT LEFT(REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 121),'-',''),':',''),'.',''),' ',''),16)

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden