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
Please sign in to leave a comment.
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.
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)
Indeed vasily chernov you were mistaken
https://youtrack.jetbrains.com/issue/DBE-10816