CURRENT_TIMESTAMP

1
SELECT CURRENT_TIMESTAMP() as now;

1
INSERT INTO audit_log (action, user_id, created_at)
2
VALUES ('LOGIN', 'USER-001', CURRENT_TIMESTAMP());

1
SELECT *
2
FROM orders
3
WHERE order_date >= DATE_TRUNC('DAY', CURRENT_TIMESTAMP())
4
  AND order_date < DATEADD('DAY', 1, DATE_TRUNC('DAY', CURRENT_TIMESTAMP()));

1
SELECT
2
  CURRENT_TIMESTAMP() as current_ts,
3
  CURRENT_DATE() as current_dt,
4
  CURRENT_TIME() as current_tm,
5
  SYSDATE() as sys_date;