Re: [HACKERS] ISO dates with European Format

Thomas Lockhart wrote:
> 
> > I have the requirement for ISO dates with European format and would
> > like to change backend/utils/adt/dt.c:EncodeDateTime() and EncodeDateOnly()
> > to effect this if this is a general requirement.
> 
> What is "ISO dates with European format"? Is it a combination of ISO
> date output with European-style input (which I think can be done
> already), or something else? afaik ISO-8601 is specific about
> suggested formats, and makes no distinction between European and other
> conventions. Can you give examples? TIA

Sure -
 coza=> set datestyle to 'SQL,European'; SET VARIABLE coza=> select registrationdate from accounts where domain =
'flame.co.za';registrationdate            --------------------------- 02/06/1997 00:00:00.00 SAST (1 row)
 

The above result is correct for dd/mm/yyyy styles
 coza=> set datestyle to 'ISO,European'; SET VARIABLE coza=> select registrationdate from accounts where domain =
'flame.co.za';  registrationdate       ---------------------- 1997-06-02 00:00:00+02 (1 row)
 

Instead of 02-06-1997 00:00:00+02

If ISO is specific regarding formatting of days, month and year then I feel that
the "set datestyle to 'ISO,European'" should give an error. However, I would
personally
prefer it to format the result as "dd-mm-yyyy".

--------
Regards
Theo