SQL NOW() Function


The SQL NOW() is a function, and returns a date and time specifying the current date and time according your computer's system date and time.

It can be used in SELECT statement as well in where clause.


Search Keys

  • sql now function
  • sql now
  • sql server now
  • sql server date now
  • sql date now
  • t sql now
  • mssql date now
  • sql query now
  • sql now format
  • sql server now date
  • now function
  • sql server select now
  • sql year now
  • sql get date now
  • sql datetime now
  • sql server current date
  • sql current date
  • sql datepart
  • sql date today
  • sql getdate format
  • sql get date
  • sql date functions
  • current date sql
  • sql server get date

SQL NOW() Syntax

The below syntax is used to get current date and time using NOW() function.

For SQL SERVER / MY SQL / MS ACCESS


SELECT NOW();


SQL NOW() Example

The following SQL SELECT statement will return current date and time using NOW() function.


SELECT NOW() AS 'Current Date and Time';

The result of above query is:

Current Date and Time
15-06-2012 16:36:30

Search Keys

  • sql server sysdate
  • sql system date
  • sql server todays date
  • date function
  • sql server system date
  • getdate sql format
  • get current date sql
  • convert getdate
  • mssql datepart
  • sql server get date from datetime
  • sql date month
  • sql query to get current date
  • sql server current date function
  • sql for current date
  • date today sql
  • getdate t sql
  • sql get time
  • sql month date
  • extract date sql
  • sql server getdate without time
  • ms sql server datepart
  • sql server current datetime
  • sql timestamp to date
  • sql get system date