Jump to content
Main menu
Main menu
move to sidebar
hide
SELECT basics
quiz
SELECT from world
quiz
SELECT from nobel
quiz
SELECT in SELECT
quiz
SUM and COUNT
quiz
JOIN
quiz
More JOIN
quiz
Using NULL
quiz
Self JOIN
quiz
Reference
NoSQL zoo
SELECT
Functions
SELECT .. WHERE
SELECT .. GROUP BY
SELECT .. JOIN
SELECT .. SELECT
INSERT .. VALUES
INSERT .. SELECT
UPDATE
DELETE
CREATE TABLE
CREATE VIEW
CREATE INDEX
DROP
ALTER
UNION
LEFT JOIN
NULL
SQLZoo
Search
Search
Log in
Personal tools
Log in
Template
:
DATE and TIME ref
Template
Discussion
British English
Read
View source
View history
Tools
Tools
move to sidebar
hide
Actions
Read
View source
View history
General
What links here
Related changes
Special pages
Printable version
Permanent link
Page information
From SQLZoo
DATE and TIME Operations
Date and time types
Format a date and time
Specify a date
Match a range of dates
Subtract dates
INTERVAL of time
Components of date
Date functions
Date arithmetics
Select the oldest person
Select a record with the latest date
YYYYMMDD date format
Getting the latest record
DataWars:
Practice Data Science/Analysis with
+100 Real Life Projects
Your server today is: digitalocean-sqlzoo
Toggle limited content width
DataWars: Practice Data Science/Analysis with +100 Real Life ProjectsDataWars: Practice Data Science/Analysis with +100 Real Life ProjectsDataWars: Practice Data Science/Analysis with +100 Real Life Projects