SELECT CASE WHEN DATEPART( HH , GETDATE()) > 12 THEN CAST ( ( DATEPART( HH , GETDATE()) % 12 ) AS VARCHAR) + ' PM' ELSE CAST ( ( DATEPART( HH , GETDATE()) ) AS VARCHAR) + 'AM' END AS HourParam
SELECT substring((CONVERT(varchar(20),GETDATE(), 100)),14,(len(CONVERT(varchar(12),GETDATE(), 100))))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)