sqlpostgresqltimestamp-with-timezone

Select timestamp with time zone, but ignore seconds

I'm selecting a timestamptz from a PosgreSQL database.

I want my SELECT to return only the date, hours and minutes. No seconds. Can I set the date format in my psql SELECT to accommodate this?

Solution

  • You can use date_trunc() to truncate seconds and still return a timestamptz:

    SELECT date_trunc('minute', ts_col) ...

    Or you can use to_char() to return a formatted timestamp as text any way you like:

    SELECT to_char(ts_col, 'YYYY-MM-DD HH24:MI') ...

    This formats the timestamptz value according to your current timezone setting. See: