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.

regards.

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.


Mime
View raw message