In this article, I found a sql query to find day, month and year from the current or any date using inbuilt functions such as DATEPART() or DAY(), MONTH() and YEAR() functions.
SELECT
DATEPART(DD,GETDATE()) AS Day,
DATEPART(MM,GETDATE()) AS Month,
DATENAME(YYYY,GETDATE()) AS Year
(OR)
SELECT
DATEPART(DAY,GETDATE()) AS Day,
DATEPART(MONTH,GETDATE()) AS Month,
DATEPART(YEAR,GETDATE()) AS Year
Output
--------
Day Month Year
21 3 2016
Post your comments / questions
Recent Article
- Fix-Gradient effect turning to gray in after effects
- How to blur an image in python?
- ModuleNotFoundError: No module named 'whois' in Python GoviralHost Without Terminal
- How to Convert Image to Pencil Sketch in Python?
- AttributeError: module 'urllib' has no attribute 'request' - Python
- How to Extract audio from video files using python?
- PermissionError: [Errno 13] Permission denied: 'shampoo_sales.csv' - Python
- [WinError 145] The directory is not empty: 'FolderPath' - Python
Related Article