PostgreSQL???????????????????

?PostgreSQL?????????????????????????????????????????????????????????

???????

PostgreSQL ??????????????????????????????????????????????????????????????????????????????????????????????

1. ??????????

???????????????????

CURRENT_DATE???????????????

CURRENT_TIME???????????????

CURRENT_TIMESTAMP???????????

CURRENT_TIME(precision)?????????????

LOCALTIME?????????????????

LOCALTIMESTAMP?????????????????????????

???????????????????????????????????

2. ??????????

???????????????????

now()????????????????????

timeofday()???????????????????

statement_timestamp()????????????????

??????????????????????????????????????

???????

??????????????????

highgo=# begin;BEGINhighgo=# select now(); now------------2023-10-18 14:22:45.678901+08:00 (1 row)highgo=# select statement_timestamp();statement_timestamp------------2023-10-18 14:22:47.890123+08:00 (1 row)

??????????? now() ? statement_timestamp() ???????????now() ????????????????? statement_timestamp() ????????????????

????????

????????????PostgreSQL ?????????????????????????

highgo=# create table t(date date);CREATE TABLEhighgo=# insert into t values (date '2023-10-18');INSERT 0 1

?????????????????????????

highgo=# insert into t values (timestamp '2023-10-18 14:22:45.678901+08:00');INSERT 0 1

???????PostgreSQL???????? ISO, MDY?????????????????????

highgo=# set datestyle = 'YMD';

???????

????????????????????????

highgo=# select time '12:09:00.123456';time---------12:09:00.123456 (1 row)

???????MySQL ????????? PostgreSQL ????????

??

? PostgreSQL ???????????????????????????????????????????????????????? CURRENT_TIMESTAMP ? LOCALTIMESTAMP?????????????????? now() ? timeofday()?

???????????????????????????????????

转载地址：http://qcowz.baihongyu.com/

你可能感兴趣的文章

postgresql 不需要付费_使用数据传输在PostgreSQL执行外部连接运算符

查看>>

postgresql 主从配置_生产环境postgresql主从环境配置

查看>>

postgresql 函数&存储过程；递归查询

查看>>

PostgreSQL 分组聚合查询中 filter 子句替换 case when

查看>>

PostgreSQL 同步流复制锁瓶颈分析