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
