1657843200000000000 16581024000000000001658188800000000000
我有一个查询,其中一列是DATE
类型。我试图将其转换为纳秒表示的时间戳与日期相关联:
<表类>
输入输出 tbody><<tr>2022-07-15 1657843200000000000 2022-07-18 1658102400000000000 2022-07-19 1658188800000000000 表类>
可以使用datediff函数返回从Unix纪元开始以来的纳秒数,即1970-01-01:
with source_data as
(
select
COLUMN1::date as INPUT
from (values
('2022-07-15'),
('2022-07-18'),
('2022-07-19')
)
)
select INPUT
,datediff(nanoseconds, '1970-01-01'::date, INPUT) as OUTPUT
from SOURCE_DATA
;