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, 3258🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...