Postgresql常用語句

日期

SELECT now() as now_with_timezone

     , localtimestamp::date   + interval '1s' as local_time_without_timezone

     , current_date                + interval '1m' as current_date_without_timezone

     , date_trunc('day', now())  as truncate_time                                                     //00:00:00

     , now()::date                  + interval '1d'  - interval '1ms' as today_lastmonent  //23:59:59