Αποτελέσματα Αναζήτησης
20 Νοε 2013 · Returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is included. More on MSDN.
The GETDATE () function returns the current database system date and time, in a 'YYYY-MM-DD hh:mm:ss.mmm' format. Tip: Also look at the CURRENT_TIMESTAMP function.
9 Απρ 2021 · SQL Server provides several different functions that return the current date time including: GETDATE(), SYSDATETIME(), and CURRENT_TIMESTAMP. The GETDATE() and CURRENT_TIMESTAMP functions are interchangeable and return a datetime data type.
30 Δεκ 2022 · Transact-SQL reference for the GETDATE function, which returns the current database system time as a datetime value.
17 Μαΐ 2021 · GETDATE () - returns the date and time of the machine the SQL Server is running on. GETUTCDATE () - returns the date and time of the machine the SQL Server is running on as UTC.
3 Σεπ 2024 · 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.
To get the current date and time of the database server, you use the SQL CURRENT_TIMESTAMP function as shown below: CURRENT_TIMESTAMP. Code language: SQL (Structured Query Language) (sql)
