Thread: What is the datetime type equivalent from v7.0.2 to v7.3.1???

What is the datetime type equivalent from v7.0.2 to v7.3.1???

From
P G
Date:
In postgres 7.0.2 there was a type called datetime
that Cobalt servers use.  What is the equivalent in
version 7.3.1?  Is it timestamp?  And if so, what are
the differences between the two types or how can I
make sure that timestamp behaves the same as the
previous datetime type?

TIA.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

Re: What is the datetime type equivalent from v7.0.2 to v7.3.1???

From
Tom Lane
Date:
P G <pg_dba@yahoo.com> writes:
> In postgres 7.0.2 there was a type called datetime
> that Cobalt servers use.  What is the equivalent in
> version 7.3.1?  Is it timestamp?

No, timestamptz (timestamp with time zone).

            regards, tom lane