Home Forums SQL Server 7,2000 Administration SQL server date formate RE: SQL server date formate

  • October 13, 2008 at 12:50 am

    #883983

    Try the following way:

    selectreplace (replace (left (replace (replace (convert (varchar, getdate(), 120), '', ''), ':', ''), 16), '-', ''), ' ', '') + '.txt'

    🙂