Re: time format

On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
> 
> ok, bat each time where i want to do select .. a nie tu use to_char,
> but it should be in function timestamp_out to convert time to string
> it would be easer and faster.
I don't think it will too much faster :-)
BTW, for example  the Oracle allows to define  default date/time outputformat by same way as for to_char(). TODO (?):
        SET TIMESTAMP_FORMAT = 'MM/DD/YYYY HH24:MI:SS';
        SELECT 'now'::timestamp;               timestamp                  ----------------------------
01/05/200410:25:01
 

But it require check (be sure)  that defined format is possible withoutproblems convert back from string  to timestamp.
Forthis Thomas didn'tlike this idea.
 
I think dynamic timestamp format is final solution of all problems withPostgreSQL date/time formats.
Comments?
   Karel

> 
> On Sat, 3 Jan 2004, Kurt Roeckx wrote:
> 
> > On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote:
> > >
> > > but what about default style ?
> > > first time when i saw DateStyle i thought that i can use it like C/C++
> > > function strftime. I would be not bad idea to have custom data style :)
> >
> > Use to_char() function to put it in any format you want.
> >
> >
> > Kurt
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/