yesterday SELECT NOW() - INTERVAL '1 DAY'; --Unrelated to the question, but PostgreSQL also supports some shortcuts: SELECT 'yesterday'::TIMESTAMP, ...
確定! 回上一頁