MS SQL: Date Format
Posted on May 17, 2024 (Last modified on July 21, 2024) • 1 min read • 33 wordsMicrosoft SQL Server date Format
Date without time
CONVERT(varchar, GETDATE(), 112)
Date with time
CONVERT(varchar, GETDATE(), 112) + CONVERT(varchar, GETDATE(), 108)
or
CONVERT(varchar, GETDATE(), 112) + CONVERT(VARCHAR, DATEPART(hh, GetDate())) + CONVERT(VARCHAR, DATEPART(mi, GetDate()))
More information about DateTime: https://learn.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver16