Re: DateStyle (was Re: Per-database/schema settings) - Mailing list pgsql-hackers

On Thu, 6 Jul 2000, Peter Eisentraut wrote:

> Thomas Lockhart writes:
> 
> > I've been pretty resistant to having a fully-tailorable native output
> > capability, since it would be possible to generate date strings which
> > can not be correctly interpreted on input.
> 
> Good point. Let them use to_char().
> 
Small note, to_char() has good friend to_timestamp() and this second
routine must allow interpret all output from to_char() to PG internal
datetype.

test=# select to_timestamp( to_char( now(), '"perverse date/time: "Y,YYY  
FMMonth-DD HH24:MI:SS'), '"perverse date/time: "Y,YYY FMMonth-DD
HH24:MI:SS') = now();?column?
----------t
(1 row)  
                    Karel