Computer Notes

Header Right

Home » Sql » Functions » SQL GETDATE() Function

SQL GETDATE() Function

By Dinesh Thakur

The simplest of the date/time functions is one that returns the current date and time. In Microsoft SQL Server, the function is named GETDATE. This function has no arguments. It merely returns the current date and time. For example:

SELECT GETDATE ()

Brings back an expression with the current date and time. Since the GETDATE function has no arguments, there is nothing between the parentheses. Remember, that a date/time field is a special data type that contains both a date and a time in a single field. An example of such a value is:

2009-07-15 08:48:30

This value refers to the 15th of July 2009, at 48 minutes and 30 seconds past 8 a.m.

 

You’ll also like:

  1. SQL NVL Function
  2. SQL: DECODE Function
  3. SQL DATEPART() Function
  4. SQL CAST() Function
  5. SQL: COUNT Function
Like/Subscribe us for latest updates     
About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.