Thread

1. timestamp changed on 7.1.1 ?

   Alex <alex@quad.com.ar> — 2001-05-16T04:35:05Z

   Hello there!
   
   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"
   
   In all the docs I've read (7.2 and 7.1) it mentions 'timestamp' AND
   'timestamp [ with time zone ]' as two different Data Types, and it used to
   be like that in previous releases. But somehow, somwhere in 7.1.1 this is no
   longer true, timestamp seems to be forced as 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.
   
   Thanks in advance
   
   Alex
   
   
   

2. Re: timestamp changed on 7.1.1 ?

   Alexander Dederer <dederer@spb.cityline.ru> — 2001-05-16T11:32:03Z

   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.