Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATA TYPES (DATES (Formatting dates (DATE_FORMAT(date, format); (SELECT…
DATA TYPES
DATES
-
-
-
CURTIME(), CURDATE(), NOW()
Formatting dates
-
DATE_FORMAT(date, format);
SELECT DATE_FROMAT('...', '...') FROM ....;
Date math
DATEDIFF(..., ...) tells the difference in days
DATE_ADD(<date>, INTERVAL 'how many' <unit>);
-
-
-
-
-
-
-