Mega Code Archive
Categories
/
PostgreSQL
/
Date Timezone
To_char(now(), HH
postgres=# SELECT to_char(now(), 'HH:MI PM') AS the_time; the_time ---------- 03:20 PM (1 row) postgres=#