Home > mailing lists

converting interval to timestamp - Mailing list pgsql-sql

From	teknokrat
Subject	converting interval to timestamp
Date	August 1, 2003 00:16:37
Msg-id	bgbeoe$62e$1@localhost.localdomain Whole thread Raw
Responses	Re: converting interval to timestamp (Mike Rylander <miker@n2bb.com>) Re: converting interval to timestamp (Jonathan Gardner <jgardner@jonathangardner.net>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: "Alexander M. Pravking"
Date: 31 July 2003, 22:31:26
Subject: Problem with looping on a table function result

From: "Knut P. Lehre"
Date: 01 August 2003, 00:18:23
Subject: length of recordset read through a cursor

converting interval to timestamp - Mailing list pgsql-sql

Previous

Next