PG生成时间戳
毫秒时间戳
select extract(epoch from create_date) * 1000;
select extract(epoch from timestamp '2023-01-01 01:01:01') * 1000;
PG数据为空替换
select coalesce(create_by, 'system');
PG大版本 12
PG生成时间戳
毫秒时间戳
select extract(epoch from create_date) * 1000;
select extract(epoch from timestamp '2023-01-01 01:01:01') * 1000;
PG数据为空替换
select coalesce(create_by, 'system');
PG大版本 12