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/

你可能感兴趣的文章

phpcms

查看>>

phpcms 2008 product.php pagesize参数代码注射漏洞

查看>>

phpcms V9 自定义添加全局变量{DIY_PATH}方法

查看>>

Redis五种核心数据结构的基本使用与应用场景

查看>>

Redis五种数据结构简介