SQL Editor

SQL Current Offset Times Example

Task:

Demonstrate 6 functions in SQL Server that return the current system datetime.
Click here for details on Dates.
 
 1 Record
CURRENT_TIMESTAMP SYSDATETIME SYSDATETIMEOFFSET SYSUTCDATETIME GETDATE GETUTCDATE
10/7/2024 11:54:26 PM 10/7/2024 11:54:26 PM 10/7/2024 11:54:26 PM -07:00 10/8/2024 6:54:26 AM 10/7/2024 11:54:26 PM 10/8/2024 6:54:26 AM
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.