Hello,
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
derby.
I tried using {fn timestampdiff(SQL_TSI_SECOND,
current_timestamp,timestamp('1970-01-01-00.00.00')}
But this doesnt give me the exact result as fetched by UNIX_TIMESTAMP
function.
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.
