db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilona Gaweda <Ilona.Gaw...@Sun.COM>
Subject Re: INTERVAL statement
Date Mon, 05 Sep 2005 09:24:09 GMT
ok I've solved problem

c_expiration = {fn TIMESTAMPADD(SQL_TSI_HOUR, 2, CURRENT_TIMESTAMP)}

Ilona Gaweda wrote:
> Hi All,
> 	I'm porting TPC-W java implementation into derby, but I have an issue
> with few statements containing INTERVAL. Have any of you used it? Is it
> supported by derby ?
> 
> Example statement from MySQL is:
> UPDATE customer SET c_login = NOW(), c_expiration = (CURRENT_TIMESTAMP +
> INTERVAL 2 HOUR) WHERE c_id = ?
> 
> regards,
> Ilona
> 
> 


Mime
View raw message