Collections:
Getting Year, Month and Day Out of DATETIME Values in SQL Server
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL?
✍: FYIcenter.com
You can use DATEPART() to get any part of the DATETIME value. But to get year, month and day, you can use 3 specific functions: YEAR(), MONTH() and DAY(). These functions are equivalent to DATEPART() as:
YEAR(date) = DATENAME(year, date) MONTH(date) = DATENAME(month, date) DAY(date) = DATENAME(day, date)
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),YEAR(@birth_date)) + '.' + CONVERT(VARCHAR(10),MONTH(@birth_date)) + '.' + CONVERT(VARCHAR(10),DAY(@birth_date)); GO You were born on 1987.5.19
⇒ Difference Between GETDATE() and GETUTCDATE() in SQL Server
⇐ Getting Parts of DATETIME Values as Integers in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-14, 3300🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...