[SQL] converting interval to timestamp

[teknokrat]

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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match