SQL · Theory

DATE_FORMAT()

Theory

219/439

DATE_FORMAT()

DATE_FORMAT() is simple if you keep it on paper. Priya uses it for a DATE_FORMAT dry-run in a first job task.

Do DATE_FORMAT() once by hand. one DATE_FORMAT step Priya can write from memory. Change one input. Say the new result out loud.

Skip DATE_FORMAT() and only reciting the name of DATE_FORMAT shows up in a first job task.

Priya ships DATE_FORMAT() in a first job task. That is the use case worth saying.

DATE_FORMAT() miss — only reciting the name of DATE_FORMAT. Fix it before you talk about advanced SQL.

After DATE_FORMAT(), Priya should still remember only reciting the name of DATE_FORMAT.

Viva for DATE_FORMAT(): what it is → one DATE_FORMAT step Priya can write from memory → the mistake (only reciting the name of DATE_FORMAT).

Exam tip

Say DATE_FORMAT() in one breath, then one DATE_FORMAT step Priya can write from memory, then only reciting the name of DATE_FORMAT.

DATE_FORMAT() — sample query

-- DATE_FORMAT()
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;

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

Short notes

DefDATE_FORMAT() — Priya uses it for a DATE_FORMAT dry-run in a first job task.
RuleDATE_FORMAT() → one DATE_FORMAT step Priya can write from memory.
RememberDATE_FORMAT() + InnoDB (a first job task).
UseDATE_FORMAT() in a first job task (a DATE_FORMAT dry-run).
TrapDATE_FORMAT() — only reciting the name of DATE_FORMAT.
ExDATE_FORMAT() → a DATE_FORMAT dry-run.

-- DATE_FORMAT() 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;

DATE_FORMAT()

DATE_FORMAT() — sample query

Short notes

Questions

DATE_FORMAT()

DATE_FORMAT() — sample query

Short notes

Questions