proposal - custom format for date, timestamp
in [PgSql]
|
Prev: [HACKERS] proposal - custom format for date, timestamp
Next: [HACKERS] "caught_up" status in walsender
From: Tom Lane on 2 Jun 2010 10:26 Pavel Stehule <pavel.stehule(a)gmail.com> writes: > I thinking about request on custom datetime format. My first idea is: > a) add new datestyle format "custom" > b) add new GUC variables - custom_date_format, custom_time_format, > custom_timestamp_format Ick. Why not just put them in one variable. datestyle = 'custom yyyy mm dd' Interrelated GUCs are really painful. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Pavel Stehule on 2 Jun 2010 11:47
2010/6/2 Tom Lane <tgl(a)sss.pgh.pa.us>: > Pavel Stehule <pavel.stehule(a)gmail.com> writes: >> I thinking about request on custom datetime format. My first idea is: > >> a) add new datestyle format "custom" >> b) add new GUC variables - custom_date_format, custom_time_format, >> custom_timestamp_format > > Ick. Â Why not just put them in one variable. > Â Â Â Â datestyle = 'custom yyyy mm dd' > Interrelated GUCs are really painful. I understand, but personally I dislike mix two different values - name and format together. And what more - we need separate formats for date, time and timestamp. It is differnet than Oracle because Oracle uses only one datatype for all. Regards Pavel > > Â Â Â Â Â Â Â Â Â Â Â Â regards, tom lane > -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |