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.



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