時間:2024-02-07 12:09作者:下載吧人氣:18
1. 日期格式轉化(參考)
select beg_time, end_time, extract(epoch from to_timestamp(end_time,’yyyy-mm-dd-HH24-MI-SS-US’))-extract(epoch from to_timestamp(beg_time,’yyyy-mm-dd-HH24-MI-SS-US’)) from cdb_all_iu_data where beg_time > ‘2017-09-21’
網友評論