db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Fetch the hour part from the timestamp value
Date Mon, 31 May 2010 03:19:26 GMT
> 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

Mime
View raw message