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 Mon, 31 May 2010 05:44:37 GMT

Here, I am again stuck with date formatting.
I read that timestamp format is yyyy-mm-dd hh[:mm[:ss[.nnnnnn]]]
Can we change is to other formats? Please advice!

Also , I wanted to know if anyone got some solution for UNIX_TIMESTAMP in
I tried using {fn timestampdiff(SQL_TSI_SECOND,
But this doesnt give me the exact result as fetched by UNIX_TIMESTAMP
Is there any other way to find an exact value?
Thanks in advance!

kirru23 wrote:
> Thanks a lot Bryan!
> That link was very helpful !
> Bryan Pendleton-3 wrote:
>>> I have a timestamp field in my table and I want to know how we can fetch
>>> only the hour part from the timestamp in derby.
>> There is an HOUR() function in Derby:
>> http://db.apache.org/derby/docs/10.6/ref/rrefhourfunc.html
>> thanks,
>> bryan

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

View raw message