db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Newsham" <jnews...@referentia.com>
Subject RE: CURRENT_TIME function
Date Mon, 03 Mar 2008 16:57:39 GMT

For your scenario, use System.nanoTime() instead.  This provides a time
value (in nanoseconds, so you'll have to scale it appropriately) which is
not tied to the system clock.  It is only appropriate for calculating
elapsed time (not time relative to a fixed clock such as "wall time"), but
this is fine for your purposes.  

Jim

> -----Original Message-----
> From: musky [mailto:muskvar@gmail.com]
> Sent: Monday, March 03, 2008 2:45 AM
> To: derby-user@db.apache.org
> Subject: Re: CURRENT_TIME function
> 
> 
> 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