how to select hours and minutes in time in postgres code example Example: postgresql today - 1 year select now() - INTERVAL '1 YEAR';