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.

You can also search these topics using sql server date now, sql server now date, sql server select now, sql server current date, sql getdate format, sql date functions, 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
You can also search these topics using sql server sysdate, sql server todays date, sql server system date, getdate sql format, get current date sql, sql server get date from datetime, sql query to get current date, sql server current date function, sql for current date, sql server getdate without time, ms sql server datepart, sql server current datetime, sql timestamp to date, sql get system date.