converting interval to timestamp

From: teknokrat <teknokrat(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: converting interval to timestamp
Date: 2003-07-31 16:05:31
Message-ID: bgbeoe$62e$1@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

The difference of two dates/timestamps always gives an interval. is
there a way to convert this interval into number such as number of
milliseconds or number of days?

Also does anyone know what field type an interval would map to in jdbc?

thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Charles Hauser 2003-07-31 19:18:49 RI_ConstraintTrigger_11264756
Previous Message Rado Petrik 2003-07-31 12:12:01 Problem login to phpPgAdmin 2.x and 3.x