Here, you can learn what time is it in UTC time now and what the most accurate time now is, use our UTC time zone converter designed to easily convert time from current time in UTC to one of over a hundred presently existing time zones, as well as use some useful links at the bottom of the page collected for you by the experts of our team. View the UTC to PST conversion below. Coordinated Universal Time is 7 hours ahead of Pacific Standard Time. Convert more time zones by visiting the time zone page and clicking on common time zone conversions. Or use the form at the bottom of this page for easy conversion.-->
Slide kitchen fridge freezer space saver organizer. Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse
Returns the current database system timestamp as a datetime value. The database time zone offset is not included. This value represents the current UTC time (Coordinated Universal Time). This value is derived from the operating system of the computer on which the instance of SQL Server is running.
SYSDATETIME and SYSUTCDATETIME have more fractional seconds precision than GETDATE and GETUTCDATE. SYSDATETIMEOFFSET includes the system time zone offset. SYSDATETIME, SYSUTCDATETIME, and SYSDATETIMEOFFSET can be assigned to a variable of any of the date and time types.
For an overview of all Transact-SQL date and time data types and functions, see Date and Time Data Types and Functions (Transact-SQL).
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
Transact-SQL statements can refer to GETUTCDATE anywhere they can refer to a datetime expression.
GETUTCDATE is a nondeterministic function. Views and expressions that reference this function in a column cannot be indexed.
3 Utc Is When Pst
The following examples use the six SQL Server system functions that return current date and time to return the date, time or both. The values are returned in series; therefore, their fractional seconds might be different.
A. Getting the current system date and time
B. Getting the current system date
C. Getting the current system time
Pst To Utc Time Conversion
Est To Utc Time Zone Conversion
CAST and CONVERT (Transact-SQL)
AT TIME ZONE (Transact-SQL)