Tuesday , December 24 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Tag Archives: DATE Functions in SQL Server

GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME Functions in SQL Server(TSQL)

dbtut February 23, 2019 MSSQL, TSQL 0

I will explain GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME functions in this article. GETDATE Function in SQL Server(TSQL): We can obtain current database timestamp as …

DAY, MONTH and YEAR Functions in SQL Server(TSQL)

dbtut February 22, 2019 MSSQL, TSQL 0

We can find the day using DAY function, month using MONTH function and year using YEAR function from a date. It takes the date() …