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

Home > SQL Server

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

Q

What Are the Date and Time Functions Supported by SQL Server 2005 in SQL Server Transact-SQL?

✍: FYIcenter.com

A

SQL Server 2005 supports n character string functions:

DATEADD(datepart, number, date) - Returning the same date and time value with one part added with the "number".
DATEDIFF(datepart, startdate, enddate) - Returning an integer representing the difference of the specified part between two date and time values.
DATENAME(datepart, date) - Returning the name string of the specified part of the input date.
DATEPART(datepart, date) - Returning an integer representing the specified part of the input date.
DAY(date) - Returning an integer representing the day part of the input date.
GETDATE() - Returning a date and time value representing the current date and time.
GETUTCDATE() - Returning a date and time value representing the current date and time in UTC (Coordinated Universal Time or Greenwich Mean Time).
MONTH(date) - Returning an integer representing the month part of the input date.
YEAR(date) - Returning an integer representing the year part of the input date.

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

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-20, 540👍, 0💬

Converting DATETIME and NUMERIC Values in SQL Server
Are DATETIME and NUMERIC Values Convertible in SQL Server Transact-SQL? Are datetime and numeric value convertible? The answer is yes. Here are the main rules on DATATIME and NUMERIC value conversions: During the conversion a DATETIME value will be treated as a NUMERIC value with the number of days ... 2017-02-22, 652👍, 0💬

Incrementing or Decrementing Parts of DATETIME Values in SQL Server
How To Increment or Decrement Parts of DATETIME Values in SQL Server Transact-SQL? If you want to increment or decrement one part of a date and time value, you can use the DATEADD() function in the following format: DATEADD(datepart, number, date) returns DATETIME: "date" - the input date "number" -... 2017-02-20, 615👍, 0💬

Date and Time Functions Supported by SQL Server 2005 in SQL Server
What Are the Date and Time Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports n character string functions: DATEADD(datepart, number, date) - Returning the same date and time value with one part added with the "number". DATEDIFF(datepart, startdate, enddate) ... 2017-02-20, 541👍, 0💬

Subtracting a DATETIME Value from Another DATETIME Value in SQL Server
Can a DATETIME Value Be Subtracted from Another DATETIME Value in SQL Server Transact-SQL? Can a datetime value be subtracted from another datetime value? The answer is yes. The subtract operation can be performed by the subtract operator (-) as: datetime1 - datetime2: Returning a DATETIME value cal... 2017-02-20, 445👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.