select ((extract(day from ((timestamp '2011-09-01 01:00:00') - (timestamp '1970-01-01 00:00:00')))-1)*24*3600*1000 + (24-extract(hour from ((timestamp '2011-09-01 01:00:00') - (timestamp '1970-01-01 00:00:00'))))*3600*1000 + extract(minute from ((timestamp '2011-09-01 01:00:00') - (timestamp '1970-01-01 00:00:00')))*60*1000 )
Get GMT time from timestamp by SQL
最新推荐文章于 2022-07-01 15:45:34 发布