Обсуждение: 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???

От
P G
Дата:
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???

От
Tom Lane
Дата:
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