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, 1380🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...