Returns the current system date and time.
getdate()
Assumes a current date of November 25, 1995, 10:32 a.m.:
select getdate()
Nov 25 1995 10:32AM
Assumes a current date of November:
select datepart(month, getdate())
11
Assumes a current date of November:
select datename(month, getdate())
November
getdate, a date function, returns the current system date and time.
For more information about date functions, see “Date functions”.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute getdate.
Datatypes Date and time datatypes
