Hi,

You might want to refer the CURRENT_TIME function here

http://db.apache.org/derby/docs/dev/ref/rrefsqlj33772.html#rrefsqlj33772

a reply to a previous datetime arithmetic question here

http://mail-archives.apache.org/mod_mbox/db-derby-user/200501.mbox/[EMAIL 
PROTECTED]

Pls note the following line in the derby reference manual in relation to that function

"the value returned does not change if it is executed more than once in a single statement"

Also just being curious, why can't you just display the time using logic in the java program itself?

Would it be OK for you to please mention the scenario in which you would want to do this?

Narayanan

musky wrote:
i want to retrieve the current time from derby every second and display it in
my java program using a daemon thread that is scheduled to run every
second.how do i go about doing this.
please help.
regards.

Reply via email to