On 1/16/06, Danny <[EMAIL PROTECTED]> 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?
Try "VALUES CURRENT_TIMESTAMP" -- http://db.apache.org/derby/docs/10.1/ref/rrefsqlj15866.html Dan
