You should know this ⏰ #SQL #dataengineering #dataanalytics #datascience #sqlserver #database #data

preview_player
Показать описание
This is how you can retrieve the current date in SQL SERVER 😎😎😎

GETDATE() - Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running.

SYSDATETIME() - Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running.

CURRENT_TIMESTAMP – Returns the current database system timestamp as a datetime value, without the database time zone offset. CURRENT_TIMESTAMP derives this value from the operating system of the computer on which the instance of SQL Server runs.

🔥PLEASE LIKE and SUBSCRIBE🔥 - this will boost our motivation to create even more amazing videos.

Be a SQL HERO!

You should know this ⏰ #SQL #dataengineering #dataanalytics #datascience #sqlserver #database #dba #data #programming
Рекомендации по теме
welcome to shbcf.ru