Published on: 01 September, 2013


Posted by andy | 1690 views 0 likes 0 favourites 0 comments
Tumblr Digg Google Plus

The SQL NOW() function is used to return current database server date and time.

Example Customer Table

The following data table is for example only.

ID Name Age
1 Thomas Anderson 45
2 Andrew Golden 38
3 Ken Tom 30
4 Andrew Golden 36
5 Timothy Kirk 32
6 Kelly Smith 39

Example of Running SQL Query

SELECT ID, Name, Age, NOW() AS Date
FROM Customers

After running the above query, it will return the following result.

ID Name Age Date
1 Thomas Anderson 45 2013-09-24 11:47:00.157
2 Andrew Golden 38 2013-09-24 11:47:00.157
3 Ken Tom 30 2013-09-24 11:47:00.157
4 Andrew Golden 36 2013-09-24 11:47:00.157
5 Timothy Kirk 32 2013-09-24 11:47:00.157
6 Kelly Smith 39 2013-09-24 11:47:00.157

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.
Related Articles
Published on: 12 February, 2018

If you have a situation where you want to add a column into a table in SQL Server, it would be a good idea to perform a check first if a column has already existed in a table. Otherwise, if you try to add a duplicate column, you may get an error message when you try to add a column via SQL query.

Published on: 05 February, 2018
If you develop a website or a program that allows your users to perform a search. When the users perform a search query, you probably want to return the best match result first because it is actually more relevant to the search they need. For example, let says we have a database table contains the following list of product.