you are at Encyclopedia of SQL >> NOW()
NOW()
Returns current date and system timeSyntax
SELECT NOW()
FROM `table_name`
Example
Display table with current date and time in last column
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT `name`,`surname`,`age`,NOW()
AS dateTime
FROM `people`
result
| name | surname | age | dateTime |
|---|---|---|---|
| Paweł | Kowalski | 3 | 2009-02-15 11:40:01 |
| Piotr | Janik | 7 | 2009-02-15 11:40:01 |
| Michał | Nowak | 13 | 2009-02-15 11:40:01 |
