Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Get current time

postgres=# postgres=# SELECT current_time, 'now'::time AS time;      timetz      |     time -----------------+--------------  15:11:22.109-07 | 15:11:22.109 (1 row) postgres=#