SELECT REPLACE(CAST(convert(varchar, getdate(), 113) AS VARCHAR(11)), ' ','-') + ' ' + LTRIM(RIGHT(CONVERT(VARCHAR(30), GETDATE(), 109), 15))
SELECT GETDATE(), REPLACE(CONVERT(varchar(30), GETDATE(),106),' ','-')+' ' + LTRIM(RIGHT(CONVERT(CHAR(20), GETDATE(), 22), 11))
SQL date formats
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)