Re: [HACKERS] ISO dates with European Format

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Theo Kramer <theo(at)flame(dot)co(dot)za>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] ISO dates with European Format
Date: 1999-09-14 15:44:25
Message-ID: 37DE6D59.C53E004C@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Hmmm, a product I helped develop uses two mechanisms for specifying
> date style. First the format and second the picture. The format
> allows swapping of sub fields within a date and a picture to specify
> the output. Eg. dd/mm/yyyy as a format with a picture of 99/99/9999 or
> mm/dd/yyyy and 99/99/9999 or dd-mmm-yyyy and 99-xxx-9999. This format
> allows total control over dates (at least in Western countries) ... I
> am happy to donate the code... Windows (int the regional settings) follows
> a similar approach.

Well, this sounds interesting even if Windows *does* use the same
technique ;)

Certainly contributing the code could be useful. It could make its way
into user contrib code, into special built-in formatting functions, or
possibly into the backend as the default formatting mechanism. Without
seeing the code and understanding the tradeoffs I can't predict which
would be the most suitable, though in any case user contributed code
is a great way to test out a new technique.

If you want, post it raw or package it as user contributed code;
either way, we'll look at it. TIA

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernard Frankpitt 1999-09-14 15:47:14 Re: [HACKERS] Patch for user-defined C-language functions
Previous Message Theo Kramer 1999-09-14 15:28:21 Re: [HACKERS] ISO dates with European Format