db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Narayanan <V.Naraya...@Sun.COM>
Subject Re: CURRENT_TIME function
Date Mon, 03 Mar 2008 02:34:57 GMT
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/%3c41D92C14.5030204@gematronik.com%3e

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.
>   


Mime
View raw message