Interval field in PpstgreSQL

Answered

Hi!

Can I customize interval field in sql output?

"0 years 0 mons 0 days 0 hours 0 mins 0.391338 secs" - this form isn't comfy

3 comments
Comment actions Permalink

Hi,
DataGrip shows INTERVAL in traditional Postgres format.

If you want to change output format refer to official Postgres documentation https://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-DATESTYLE and useful link on dba StackExchange http://dba.stackexchange.com/questions/19679/how-to-set-postgresql-database-to-see-date-as-mdy-permanently

Thank you.

-1
Comment actions Permalink

Hi!

No. In DataGrip I see interval as "0 years 0 mons 0 days 0 hours 0 mins 0.391338 secs", but in psql console it looks as "00:00:00.274971"
I prefer see as in psql (and if possible without milliseconds)

1

Please sign in to leave a comment.