SQL Server Get Current Time
To obtain the current time from SQL Server, you can use the GETDATE() function. This function returns the current date and time, with a data type of datetime.
The following is a simple SQL query used to retrieve the current date and time from SQL Server:
SELECT GETDATE() AS current date and time ;
After executing this query, a column named "Current Date Time" containing the current date and time will be returned in the format of YYYY-MM-DD HH:MI:SS.sss.
Please note that the returned time will be based on the server's system clock, which may be in a different time zone. If you need to convert it to a specific time zone, you can use the AT TIME ZONE clause provided in SQL Server 2016 and later versions.
For example, converting the current time to Eastern Standard Time (US and Canada):
SELECT GETDATE() AT TIME ZONE 'Eastern Standard Time' AS current date and time ;
If you need another time zone, please replace 'Eastern Standard Time' with the corresponding time zone name.
Use GetDATe() to obtain the specified time format
Use GetDATe() to obtain the current time, and then use the Convert() function to convert the time into the format you need. Collect and organize relevant conversion methods and formats Format:
SELECT CONVERT(varchar(100), GETDATE(), 0); -- Oct 13 2017 6:13PM
SELECT CONVERT(varchar(100), GETDATE(), 1); -- 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2); -- 06.05.16
SELECT CONVERT(varchar(100), GETDATE(), 3); -- 16/05/06
SELECT CONVERT(varchar(100), GETDATE(), 4); -- 16.05.06
SELECT CONVERT(varchar(100), GETDATE(), 5); -- 16-05-06
SELECT CONVERT(varchar(100), GETDATE(), 6); -- 13 Oct 17
SELECT CONVERT(varchar(100), GETDATE(), 7); -- Oct 13, 17
SELECT CONVERT(varchar(100), GETDATE(), 8); -- 10:57:46
SELECT CONVERT(varchar(100), GETDATE(), 9); -- Oct 13 2017 5:04:02:327PM
SELECT CONVERT(varchar(100), GETDATE(), 10); -- 05-16-06
SELECT CONVERT(varchar(100), GETDATE(), 11); -- 06/05/16
SELECT CONVERT(varchar(100), GETDATE(), 12); -- 060516
SELECT CONVERT(varchar(100), GETDATE(), 13); -- 13 Oct 2017 18:15:03:370
SELECT CONVERT(varchar(100), GETDATE(), 14); -- 10:57:46:967
SELECT CONVERT(varchar(100), GETDATE(), 20); -- 2006-05-16 10:57:47
SELECT CONVERT(varchar(100), GETDATE(), 21); -- 2006-05-16 10:57:47.157
SELECT CONVERT(varchar(100), GETDATE(), 22); -- 05/16/06 10:57:47 AM
SELECT CONVERT(varchar(100), GETDATE(), 23); -- 2006-05-16
SELECT CONVERT(varchar(100), GETDATE(), 24); -- 10:57:47
SELECT CONVERT(varchar(100), GETDATE(), 25); -- 2006-05-16 10:57:47.250
SELECT CONVERT(varchar(100), GETDATE(), 100); -- Oct 13 2017 6:15PM
SELECT CONVERT(varchar(100), GETDATE(), 101); -- 05/16/2006
SELECT CONVERT(varchar(100), GETDATE(), 102); -- 2006.05.16
SELECT CONVERT(varchar(100), GETDATE(), 103); -- 16/05/2006
SELECT CONVERT(varchar(100), GETDATE(), 104); -- 16.05.2006
SELECT CONVERT(varchar(100), GETDATE(), 105); -- 16-05-2006
SELECT CONVERT(varchar(100), GETDATE(), 106); -- 13 Oct 2017
SELECT CONVERT(varchar(100), GETDATE(), 107); -- Oct 13, 2017
SELECT CONVERT(varchar(100), GETDATE(), 108); -- 10:57:49
SELECT CONVERT(varchar(100), GETDATE(), 109); -- Oct 13 2017 6:16:36:550PM
SELECT CONVERT(varchar(100), GETDATE(), 110); -- 05-16-2006
SELECT CONVERT(varchar(100), GETDATE(), 111); -- 2006/05/16
SELECT CONVERT(varchar(100), GETDATE(), 112); -- 20060516
SELECT CONVERT(varchar(100), GETDATE(), 113); -- 13 Oct 2017 18:16:54:897
SELECT CONVERT(varchar(100), GETDATE(), 114); -- 10:57:49:547
SELECT CONVERT(varchar(100), GETDATE(), 120); -- 2006-05-16 10:57:49
SELECT CONVERT(varchar(100), GETDATE(), 121); -- 2006-05-16 10:57:49.700
SELECT CONVERT(varchar(100), GETDATE(), 126); -- 2017-10-13T18:17:13.223
SELECT CONVERT(varchar(100), GETDATE(), 130); -- 23 ???? 1439 6:17:25:580PM
SELECT CONVERT(varchar(100), GETDATE(), 131); -- 23/01/1439 6:17:25:580PM