db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kirru23 <kiran.nellima...@gmail.com>
Subject Re: Format the timestamp value
Date Wed, 02 Jun 2010 03:23:20 GMT

Thank you so much bryan!
Actually I am in EST time zone and the tz gap is 5 hrs actually. So i will
try to set it to GMT and see the results.
Also, i posted in derbt users forum for an alternate solution.
Thanks for ur input!


Bryan Pendleton-3 wrote:
> 
>> Hence the difference is around 17970 seconds.
> 
> Looks pretty close to 5 hours. (5*3600=18000). Is 5 hours approximately
> your TZ correction from GMT?
> 
>> Does anyone implement any other formula for getting a more accurate
>> value.
>> I am new to derby, so pls suggest how do i consider/check the timezone .
>> Is
>> this difference due to timeze? if yes then how can I change me query to
>> consider that.
> 
> I'm not sure it's very easy to control the TZ that Derby's
> CURRENT_TIMESTAMP uses.
> 
> You could try setting TZ=GMT when running Derby, to see if the answer
> changes,
> and if the new result is closer to what you get with MYSQL.
> 
> To really get control over these behaviors, though, you probably will
> need to write your own date/time formatting code. I understand that if
> you are working in PHP this is going to be a challenge; Derby is most
> easily used in a native Java configuration, unfortunately.
> 
> You might try asking these questions on derby-users, rather than on
> derby-dev, as derby-dev tends to attract mostly Derby developers, while
> derby-users has lots of people who have dealt with Derby application
> development issues.
> 
> thanks,
> 
> bryan
> 
> 

-- 
View this message in context: http://old.nabble.com/Fetch-the-hour-part-from-the-timestamp-value-tp28726194p28749732.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.


Mime
View raw message