SQL NOW() Function

Submitted by admin on Sunday, May 1, 2011 - 08:30.

The NOW() function is an aggregate function used to return the date and time along with other column.

The NOW() function returns the result as dd/mm/yyyy HH:MM:SS AM/PM depending on your regional settings.

SQL NOW() Syntax

SELECT column_name(s),NOW() FROM TABLE

Consider the following table for this exercise

Users

Firstname	Lastname	Salary	DeptID
John	Smith	1000	1
Mathew	Simon	3000	1
Bill	Steve	2200	1
Amanda	Rogers	1800	2
Steve	Hills	2800	2
Steve	jobs	2400	2
bill	cosby	700	3

Example # 1

SELECT Salary, NOW() AS TILL_date FROM Users

Result of the Query

Salary	TILL_date
1000	23/03/2011 03:24:06 AM
3000	23/03/2011 03:24:06 AM
2200	23/03/2011 03:24:06 AM
1800	23/03/2011 03:24:06 AM
2800	23/03/2011 03:24:06 AM
2400	23/03/2011 03:24:06 AM
700	23/03/2011 03:24:06 AM

Comments

SIR,C# and SQL DATA BASE ONLY.

SIR,, CAN YOU HELP ME TO DEVELOP MY FINAL EXAM PROJECT .It has make library system using C# and SQL data base ONLY.So send me small source code and it data base pls.. emai:[email protected]

Add new comment

Add new comment
129 views