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
Â
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-14, 2821👍, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...