Date and Time functions in SQL Server

In this article I will explain you the some important Date and Time functions.
  • 2296

Introduction
In this article I will explain you the some important Date and Time functions. SQL Server provides some useful Date and Time function such as ADDTIME(), MONTH() and HOUR() etc. The following list represent the name and description of some useful date and time function.

Name Description
CURDATE() Return the current date
CURRENT DATE () Synonyms of CURDATE()
CURRENT TIME() Synonyms of CURTIME()
ADDDATE() Add dates
ADDTIME() Add times
CONVERT TZ() Convert from one time zone to another
DAY() Synonyms for DAYOFMONTH()
DAYNAME() Return the name of the weekday
DAYOFMONTH() Return the day of the month(1-31)
DAYOFWEEK() Return the weekday index of the a
EXTRACT Extract part of a date
HOUR() Extract the hour
MINUTE() Return the minute from the argument
MONTH() Return the month from date Passed

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.