SQL · Theory

CURTIME()

← All stacks

Theory

231/439

CURTIME()

Ananya only reaches for CURTIME() when CURTIME on Ananya's board has to stay correct in a campus project.

For CURTIME(), the query planner is in play. Don’t blame it until you have traced CURTIME on Ananya's board.

Skip CURTIME() and skipping the failure case for CURTIME shows up in a campus project.

Use CURTIME() when CURTIME on Ananya's board must stay clear. If a simpler SQL step works, use that instead.

If CURTIME on Ananya's board breaks under CURTIME(), check skipping the failure case for CURTIME first.

After CURTIME(), Ananya should still remember skipping the failure case for CURTIME.

Close CURTIME() with: “If I skip it, CURTIME on Ananya's board goes wrong like this: skipping the failure case for CURTIME.”

Exam tip

For CURTIME(): definition + a campus project + one failure.

CURTIME() — sample query

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

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

Short notes

DefCURTIME() — Ananya uses it for CURTIME on Ananya's board in a campus project.
RuleCURTIME() → one CURTIME step Ananya can write from memory.
RememberCURTIME() + the query planner (a campus project).
UseCURTIME() in a campus project (CURTIME on Ananya's board).
TrapCURTIME() — skipping the failure case for CURTIME.
ExCURTIME() → CURTIME on Ananya's board.

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

CURTIME()

CURTIME() — sample query

Short notes

Questions

CURTIME()

CURTIME() — sample query

Short notes

Questions