Thread: date arithmetic

Hi ALL,

I want to do date arithmetic in SQL with a column that is integer.

example

create table bob ( col1   timestamp
, col2   int4
;

where col2 represents a number of minutes.


I want to do something like

select col1 + interval col2 minutes from bob

This is doable with most other RDBMS (DB2, Oracle MS SQL) what am I
missing??

I know one option is to create col2 as interval, but does not work for me.
How can I cast int4 to "interval minutes"
-- 
View this message in context: http://www.nabble.com/date-arithmetic-tf2075353.html#a5715425
Sent from the PostgreSQL - sql forum at Nabble.com.

chrisj escreveu:
> Hi ALL,
> 
> I want to do date arithmetic in SQL with a column that is integer.
> 
> example
> 
> create table bob (
>   col1   timestamp
> , col2   int4
> ;
> 
> where col2 represents a number of minutes.
> 
> 
> I want to do something like
> 
> select col1 + interval col2 minutes
>   from bob
> 
> This is doable with most other RDBMS (DB2, Oracle MS SQL) what am I
> missing??
> 
> I know one option is to create col2 as interval, but does not work for me.
> How can I cast int4 to "interval minutes"


SELECT col1 + col2*interval '1 miunute' FROM bob;

[]s
Osvaldo
    
_______________________________________________________ 
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale 
o discador agora! 
http://br.acesso.yahoo.com