Alex wrote:
> I've just install PostgreSQL 7.1.1 and noticed that timestamp have changed
> in this release.
> for example:
> CREATE TABLE "foo" ( test timestamp );
> if you "\d foo" you will notice the column test is not a timestamp, it's a
> "timestamp with time zone"
> anyway, how can I make a timestamp data type be outputted without the time
> zone?
> I just want the so common "YYYY-MM-DD HH:MM:SS" format, not a "YYYY-MM-DD
> HH:MM:SS-time-stamp_offset"
>
> I expect to get this result *WITHOUT* rewritting existing queries.
> Any opinions would be great.
May use RULES or TRIGGERS for formating timestamp for all SELECT commands.