SQL · Theory

Date and Time Literals

Theory

314/439

Date and Time Literals

Date and Time Literals (DATE_AND_TIME_LITERALS) is a MySQL date/time helper. Dates are stored in DATE / DATETIME / TIMESTAMP columns. Always quote literals: '2026-08-19'.

Typical pattern: SELECT DATE_AND_TIME_LITERALS(…); or SELECT DATE_AND_TIME_LITERALS(dob) FROM students; NOW() / CURDATE() / CURTIME() have empty brackets — they read the clock.

DATE_FORMAT(dob, '%d-%b-%Y') is for display. DATEDIFF(end, start) is days between. INTERVAL 7 DAY is how you add a week: DATE_ADD(CURDATE(), INTERVAL 7 DAY).

Trap: comparing dates as VARCHAR. Trap: TIMESTAMP vs DATETIME timezone stories — DATETIME is ‘wall clock’, TIMESTAMP is UTC-stored (say this only if asked).

On the example next to this theory: Date and Time Literals — wHERE combines predicates with AND/OR; LIKE does pattern match.

Exam tip

DATE_AND_TIME_LITERALS: one SELECT example. Quote 'YYYY-MM-DD'.

Date and Time Literals — sample query

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL);
INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50);
SELECT * FROM products
WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

Date and Time Literals — wHERE combines predicates with AND/OR; LIKE does pattern match.

Short notes

DefDATE_AND_TIME_LITERALS works on DATE/DATETIME values.
RuleQuote date literals. NOW() for current datetime.
TrapDates as strings without a real DATE column.

SQL · Theory

Date and Time Literals

← All stacks

Theory

314/439

Date and Time Literals

Date and Time Literals (DATE_AND_TIME_LITERALS) is a MySQL date/time helper. Dates are stored in DATE / DATETIME / TIMESTAMP columns. Always quote literals: '2026-08-19'.

Typical pattern: SELECT DATE_AND_TIME_LITERALS(…); or SELECT DATE_AND_TIME_LITERALS(dob) FROM students; NOW() / CURDATE() / CURTIME() have empty brackets — they read the clock.

DATE_FORMAT(dob, '%d-%b-%Y') is for display. DATEDIFF(end, start) is days between. INTERVAL 7 DAY is how you add a week: DATE_ADD(CURDATE(), INTERVAL 7 DAY).

Trap: comparing dates as VARCHAR. Trap: TIMESTAMP vs DATETIME timezone stories — DATETIME is ‘wall clock’, TIMESTAMP is UTC-stored (say this only if asked).

On the example next to this theory: Date and Time Literals — wHERE combines predicates with AND/OR; LIKE does pattern match.

Exam tip

DATE_AND_TIME_LITERALS: one SELECT example. Quote 'YYYY-MM-DD'.

Date and Time Literals — sample query

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL);
INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50);
SELECT * FROM products
WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

Date and Time Literals — wHERE combines predicates with AND/OR; LIKE does pattern match.

Short notes

DefDATE_AND_TIME_LITERALS works on DATE/DATETIME values.
RuleQuote date literals. NOW() for current datetime.
TrapDates as strings without a real DATE column.

Date and Time Literals

Date and Time Literals — sample query

Short notes

Questions

Date and Time Literals

Date and Time Literals — sample query

Short notes

Questions