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/

你可能感兴趣的文章

OpenCV环境搭建（一）

查看>>

openCV目标识别目标跟踪 YOLO5深度学习 Python 计算机视觉计算机毕业设计源码下载

查看>>

opencv笔记（1）：图像缩放

查看>>

opencv笔记（二十四）——得到轮廓之后找到凸包convex hull

查看>>

OpenCV计算点到直线的距离数学法