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 output
format by same way as for to_char().

TODO (?):

SET TIMESTAMP_FORMAT = 'MM/DD/YYYY HH24:MI:SS';

SELECT 'now'::timestamp;
timestamp
----------------------------
01/05/2004 10:25:01

But it require check (be sure) that defined format is possible without
problems convert back from string to timestamp. For this Thomas didn't
like this idea.

I think dynamic timestamp format is final solution of all problems with
PostgreSQL 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/