How to get now() time with AM/PM in Postgresql

Question

for example when i execute the following query

select now()::time

the result will be

"10:48:28.421"

so how to get the time with AM/PM ?? (ex. 10:48:28 AM)

NOTE : My computer's location is set to English(United States) and PostgreSQL Locale is also that

Answer 1

Try this

Select to_char(now()::Time, 'HH12:MI:SS AM')

Live Demo

Output:

---

TO_CHAR
05:00:12 AM

Refer Formatting Functions

Answer 2

use to_char() and the pattern you need.