Returns the current timestamp as an INTEGER.
mysql> select NOW();
+------------+
| NOW() |
+------------+
| 1615788407 |
+------------+
1 row in set (0.00 sec)Returns the current time in local timezone in in hh:ii:ss format.
mysql> select CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 07:06:30 |
+-----------+
1 row in set (0.00 sec)Returns the current time in UTC timezone in hh:ii:ss format.
mysql> select UTC_TIME();
+------------+
| UTC_TIME() |
+------------+
| 06:06:18 |
+------------+
1 row in set (0.00 sec)Returns the current time in UTC timezone in YYYY-MM-DD hh:ii:ss format.
mysql> select UTC_TIMESTAMP();
+---------------------+
| UTC_TIMESTAMP() |
+---------------------+
| 2021-03-15 06:06:03 |
+---------------------+
1 row in set (0.00 sec)Returns the integer second (in 0..59 range) from a timestamp argument, according to the current timezone.
mysql> select second(now());
+---------------+
| second(now()) |
+---------------+
| 52 |
+---------------+
1 row in set (0.00 sec)Returns the integer minute (in 0..59 range) from a timestamp argument, according to the current timezone.
mysql> select minute(now());
+---------------+
| minute(now()) |
+---------------+
| 5 |
+---------------+
1 row in set (0.00 sec)Returns the integer hour (in 0..23 range) from a timestamp argument, according to the current timezone.
mysql> select hour(now());
+-------------+
| hour(now()) |
+-------------+
| 7 |
+-------------+
1 row in set (0.00 sec)Returns the integer day of month (in 1..31 range) from a timestamp argument, according to the current timezone.
mysql> select day(now());
+------------+
| day(now()) |
+------------+
| 15 |
+------------+
1 row in set (0.00 sec)Returns the integer month (in 1..12 range) from a timestamp argument, according to the current timezone.
mysql> select month(now());
+--------------+
| month(now()) |
+--------------+
| 3 |
+--------------+
1 row in set (0.00 sec)Returns the integer year (in 1969..2038 range) from a timestamp argument, according to the current timezone.
mysql> select year(now());
+-------------+
| year(now()) |
+-------------+
| 2021 |
+-------------+
1 row in set (0.00 sec)Returns the integer year and month code (in 196912..203801 range) from a timestamp argument, according to the current timezone.
mysql> select yearmonth(now());
+------------------+
| yearmonth(now()) |
+------------------+
| 202103 |
+------------------+
1 row in set (0.00 sec)Returns the integer year, month, and date code (in 19691231..20380119 range) from a timestamp argument, according to the current timezone.
mysql> select yearmonthday(now());
+---------------------+
| yearmonthday(now()) |
+---------------------+
| 20210315 |
+---------------------+
1 row in set (0.00 sec)Returns difference between the timstamps in format hh:ii:ss. Example:
mysql> select timediff(1615787586, 1613787583);
+----------------------------------+
| timediff(1615787586, 1613787583) |
+----------------------------------+
| 555:33:23 |
+----------------------------------+
1 row in set (0.00 sec)