Re: Fetch the hour part from the timestamp value

[Bryan Pendleton]

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