db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From musky <musk...@gmail.com>
Subject Re: CURRENT_TIME function
Date Mon, 03 Mar 2008 12:45:06 GMT

the scenario is an automated exam where the questions are fetched from the
apache derby database server.

so i wanted to fetch the time also from the server so that the local client
local clock tampering will have no effect on the current time.

how do i do this.


please help.

Narayanan-4 wrote:
> 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.

View this message in context: http://www.nabble.com/CURRENT_TIME-function-tp15796254p15802314.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message