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 INTERVAL statement
Date Mon, 05 Sep 2005 09:02:16 GMT
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