数据仓库服务 GAUSSDB(DWS)-类型转换函数:to_timestamp(double precision)

时间:2024-01-26 16:15:24

to_timestamp(double precision)

描述:把UNIX纪元转换成时间戳。

返回值类型:timestamp with time zone

示例:

1
2
3
4
5
SELECT to_timestamp(1284352323);
      to_timestamp      
------------------------
 2010-09-13 12:32:03+08
(1 row)
support.huaweicloud.com/sqlreference-820-dws/dws_06_0036.html