db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manjula G Kutty <manjula.ku...@gmail.com>
Subject Re: Select CURRENT_TIMESTAMP
Date Mon, 16 Jan 2006 19:01:48 GMT
Danny wrote:

>I know how to insert the CURRENT_TIMESTAMP of the database into a timestamp
>column in a table on an UPDATE or INSERT statement.
>
>What I need is the query to just retrieve this timestamp from the database.
>Is it accessible from one of the system tables?
>
>Thanks
>
>Danny Gallagher
>The Gainer Group
>6525 The Corners Parkway
>Suite 215
>Norcross Ga, 30092
> 
> 
>
>
>
>
>  
>
Hi Danny,

I think you can use the values statement to  retrieve the CURRENT_TIMESTAMP
 Please refer :
http://db.apache.org/derby/docs/10.1/ref/rrefselectexpression.html

thanks
Manjula

Mime
View raw message