Re: TIME vs. TIMESTAMP data type

Поиск
Список
Период
Сортировка
От Ludwig Lim
Тема Re: TIME vs. TIMESTAMP data type
Дата
Msg-id 20030206120851.54519.qmail@web80301.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: TIME vs. TIMESTAMP data type  (Tomasz Myrta <jasiek@klaster.net>)
Список pgsql-sql
Hi Tomasz:

--- Tomasz Myrta <jasiek@klaster.net> wrote:
> 
> Probably you are right, but you can cast into
> timestamp before using these functions.
> Do you really need to care amount of storage?
 I was just thinking if both TIMESTAMP and TIME have
use the same amount of space (I was think TIME might
use less space since it doesn't need to store month,
year, day as compared to TIMESTAMP), and TIMESTAMP
have more functions and is easier to cast, I might as
well use TIMESTAMP.

> Don't forget about INTERVAL type, which is very
> useful for time calculations.
> --> I'll check that one out. 


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com


В списке pgsql-sql по дате отправления:

Предыдущее
От: Maurício Sessue Otta
Дата:
Сообщение: Trigger para fazer log
Следующее
От: Christoph Haller
Дата:
Сообщение: Re: Lock timeout detection in postgres 7.3.1