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.