Collections:
Getting Parts of DATETIME Values as Integers in SQL Server
How To Get Parts of DATETIME Values as Integers in SQL Server Transact-SQL?
✍: FYIcenter.com
Sometimes, you want to one specific part of a DATETIME value as an integer to be used in your own date and time calculations. This can be done by using the DATEPART() function in the following format:
DATENAME(datepart, date) returns INT: "date" - the input date "datepart" - one of predefined date part names See other tutorials for the list of names
In following tutorial example shows you how display a birth date in a format of yyyy.m.d:
DECLARE @birth_date DATETIME; SET @birth_date = '1987-05-19 16:10:41.403'; SELECT 'You were born on ' + CONVERT(VARCHAR(10),DATEPART(year, @birth_date)) + '.' + CONVERT(VARCHAR(10),DATEPART(month, @birth_date)) + '.' + CONVERT(VARCHAR(10),DATEPART(day, @birth_date)); GO You were born on 1987.5.19
⇒ Getting Year, Month and Day Out of DATETIME Values in SQL Server
⇐ Getting Month and Weekday Names from DATATIME Values in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-14, 1826🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...