db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Scott <deni...@gmail.com>
Subject Re: Select CURRENT_TIMESTAMP
Date Mon, 16 Jan 2006 19:01:21 GMT
On 1/16/06, Danny <danny.gallagher@gainergroup.com> 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

Mime
View raw message