Re: TIME vs. TIMESTAMP data type - Mailing list pgsql-sql

From Ludwig Lim
Subject Re: TIME vs. TIMESTAMP data type
Date
Msg-id 20030206120851.54519.qmail@web80301.mail.yahoo.com
Whole thread Raw
In response to Re: TIME vs. TIMESTAMP data type  (Tomasz Myrta <jasiek@klaster.net>)
List 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 by date:

Previous
From: Maurício Sessue Otta
Date:
Subject: Trigger para fazer log
Next
From: Christoph Haller
Date:
Subject: Re: Lock timeout detection in postgres 7.3.1