SQL · Theory

ADDTIME()

Theory

228/439

ADDTIME()

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

Typical pattern: SELECT ADDTIME(…); or SELECT ADDTIME(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: ADDTIME(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Exam tip

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

ADDTIME() — sample query

-- ADDTIME()
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

ADDTIME(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

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

SQL · Theory

ADDTIME()

← All stacks

Theory

228/439

ADDTIME()

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

Typical pattern: SELECT ADDTIME(…); or SELECT ADDTIME(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: ADDTIME(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Exam tip

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

ADDTIME() — sample query

-- ADDTIME()
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

ADDTIME(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

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

ADDTIME()

ADDTIME() — sample query

Short notes

Questions

ADDTIME()

ADDTIME() — sample query

Short notes

Questions