Jump to: navigation, search

Mysql LOCALTIMESTAMP

From w3cyberlearnings

Contents

MySQL LOCALTIMESTAMP Function

This function returns the current time, and it synonyms for NOW() function.

Syntax LOCALTIMESTAMP

LOCALTIMESTAMP()

Example 1

mysql> SELECT LOCALTIMESTAMP;
+---------------------+
| LOCALTIMESTAMP      |
+---------------------+
| 2012-05-25 22:58:04 | 
+---------------------+
1 row in set (0.00 sec)


Example 2


mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2012-05-25 22:58:06 | 
+---------------------+
1 row in set (0.00 sec)


Related Links



Navigation
Web
SQL
MISC
References