Date/Time Operations and Functions in SQL Server Transact-SQL

Q

Where to find answers to frequently asked questions on Date/Time Operations and Functions in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Date/Time Operations and Functions in SQL Server Transact-SQL. Clear answers are provided with tutorial exercises on converting date and time values to integers or decimal values; incrementing and decrementing date parts; taking date differences; formatting dates to strings; getting GMT times.

Date/Time Data Type Comparison in SQL Server Transact-SQL

Get System Date and Time in SQL Server Transact-SQL

Verify Time Precision in SQL Server Transact-SQL

Adding and Removing Days on Date and Time Values in SQL Server

Converting Date and Time Values into Integers in SQL Server

Converting Integers into Date and Time Values in SQL Server

Converting DATETIME and NUMERIC Values in SQL Server

Subtracting a DATETIME Value from Another DATETIME Value in SQL Server

Date and Time Functions Supported by SQL Server 2005 in SQL Server

Incrementing or Decrementing Parts of DATETIME Values in SQL Server

DATEADD() Function Usage Examples in SQL Server

DATEDIFF() - Calculating DATETIME Value Differences in SQL Server

Calculating Age in Days, Hours and Minutes in SQL Server

Getting Month and Weekday Names from DATATIME Values in SQL Server

Getting Parts of DATETIME Values as Integers in SQL Server

Getting Year, Month and Day Out of DATETIME Values in SQL Server

Difference Between GETDATE() and GETUTCDATE() in SQL Server

Formatting Time Zone in +/-hh:mm Format in SQL Server

CONVERT() - Formatting DATETIME Values to Strings in SQL Server

Truncating DATETIME Values to Dates without Time in SQL Server

Setting New Values to Parts of a DATETIME Value in SQL Server

 

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-25, 289👍, 0💬