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/