一、對應的函數
1.sysdate
| oracle | pgsql |
| sysdate | current_date、 current_timestamp |
| nvl | coalesce |
| trunc | date_trunc(text, timestamp) |
二、參考資料
1.
What is PostgreSQL equivalent of SYSDATE from Oracle?1.sysdate
| oracle | pgsql |
| sysdate | current_date、 current_timestamp |
| nvl | coalesce |
| trunc | date_trunc(text, timestamp) |
1.
What is PostgreSQL equivalent of SYSDATE from Oracle?![oracle中的start with connect by用法[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)