SQL · Theory

CURRENT_TIMESTAMP()

Theory

230/439

CURRENT_TIMESTAMP()

CURRENT_TIMESTAMP() is simple if you keep it on paper. Priya uses it for Priya walking through CURRENT_TIMESTAMP in lab hour.

CURRENT_TIMESTAMP() on the board: one CURRENT_TIMESTAMP step Priya can write from memory. Then say what Priya walking through CURRENT_TIMESTAMP looks like after.

CURRENT_TIMESTAMP() exists so Priya can keep Priya walking through CURRENT_TIMESTAMP correct in lab hour.

CURRENT_TIMESTAMP() shows up in lab hour. Name Priya walking through CURRENT_TIMESTAMP, not “a real-world scenario”.

If Priya walking through CURRENT_TIMESTAMP breaks under CURRENT_TIMESTAMP(), check copy-pasting CURRENT_TIMESTAMP without a dry-run first.

Place CURRENT_TIMESTAMP() next to nearby SQL work — one CURRENT_TIMESTAMP step Priya can write from memory is the link.

Viva for CURRENT_TIMESTAMP(): what it is → one CURRENT_TIMESTAMP step Priya can write from memory → the mistake (copy-pasting CURRENT_TIMESTAMP without a dry-run).

Exam tip

For CURRENT_TIMESTAMP(): definition + lab hour + one failure.

CURRENT_TIMESTAMP() — sample query

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

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

Short notes

DefCURRENT_TIMESTAMP() — Priya uses it for Priya walking through CURRENT_TIMESTAMP in lab hour.
RuleCURRENT_TIMESTAMP() → one CURRENT_TIMESTAMP step Priya can write from memory.
RememberCURRENT_TIMESTAMP() + the query planner (lab hour).
UseCURRENT_TIMESTAMP() in lab hour (Priya walking through CURRENT_TIMESTAMP).
TrapCURRENT_TIMESTAMP() — copy-pasting CURRENT_TIMESTAMP without a dry-run.
ExCURRENT_TIMESTAMP() → Priya walking through CURRENT_TIMESTAMP.

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

CURRENT_TIMESTAMP()

CURRENT_TIMESTAMP() — sample query

Short notes

Questions

CURRENT_TIMESTAMP()

CURRENT_TIMESTAMP() — sample query

Short notes

Questions