PostgreSQL日期时间特殊值

  • A+
所属分类:Mysql教程

记录一些PostgreSQL日期时间特殊值:

select now();
select today;--ERROR: column "today" does not exist
-- 当做常量需要放在单引号中
select 'now'::TIMESTAMP;
select 'today'::TIMESTAMP;
select 'tomorrow'::TIMESTAMP;
select 'yesterday'::TIMESTAMP;
w3cjava

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: