Consultes senzilles - Funcions de Data i Hora
Funcions de Data i Hora
-
Les més utilitzades són:
-
CURDATE, CURTIME, NOW, YEAR
-
DATE_ADD, TIMESTAMPDIFF
-
DATEDIFF, TIMEDIFF
-
DATE_FORMAT, DAYNAME
-
DAYOFMONTH, WEEKDAY, DAYOFYEAR
-
FROM_DAYS, FROM_UNIXTIME
-
UNIX_TIMESTAMP, PERIOD_DIFF
-
Exemples de funcions
Exemples de funcions de Data i Time
SELECT CURDATE(), CURTIME(), NOW();
SELECT DATEDIFF(NOW() - INTERVAL 2 DAY, NOW());
SELECT DATE_FORMAT(NOW(), '%W, %d de %M de %Y', 'ca_ES');
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP()), UNIX_TIMESTAMP();
Exemples de funcions de Data i Time amb respostes
MariaDB [db]> SELECT CURDATE(), CURTIME(), NOW();
+------------+-----------+---------------------+
| CURDATE() | CURTIME() | NOW() |
+------------+-----------+---------------------+
| 2023-11-04 | 17:40:50 | 2023-11-04 17:40:50 |
+------------+-----------+---------------------+
MariaDB [db]> SELECT DATEDIFF(NOW() - INTERVAL 2 DAY, NOW());
+-----------------------------------------+
| DATEDIFF(NOW() - INTERVAL 2 DAY, NOW()) |
+-----------------------------------------+
| -2 |
+-----------------------------------------+
MariaDB [db]> SELECT DATE_FORMAT(NOW(), '%W, %d de %M de %Y', 'ca_ES');
+---------------------------------------------------+
| DATE_FORMAT(NOW(), '%W, %d de %M de %Y', 'ca_ES') |
+---------------------------------------------------+
| dissabte, 04 de novembre de 2023 |
+---------------------------------------------------+
MariaDB [db]> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP()), UNIX_TIMESTAMP();
+---------------------------------+------------------+
| FROM_UNIXTIME(UNIX_TIMESTAMP()) | UNIX_TIMESTAMP() |
+---------------------------------+------------------+
| 2023-11-04 17:41:18 | 1699116078 |
+---------------------------------+------------------+