HQL for selecting date only from timestamp column

d10n2000 · **Joined:** Mon Jan 12, 2004 2:24 am **Posts:** 16

Hi all,

I have the following entry in my Registration.hbm.xml:
<property name="visitDate" type="timestamp">
<column name="visit_date" not-null="false"/>
</property>

As you can see, the visitDate's type is timestamp, i.e it has
hh:mm:ss in addition of standard Date properties.

Then I want to selecting record from my registration whose
visitDate match a specific date (without timestamp), for example, Jun 8, 2004, so records like June 8, 2004, 13:45 will be selected.

Can anybody tell me the best way to do that in HQL?
I'm using Hibernate 2.1.2 and database Oracle 9i
Thanks very much in advance

gavin · **Posted:** Tue Jun 08, 2004 1:23 am

Code:

select to_date(x.visitDate) from X x

You probably need to upgrade to 2.1.4.

d10n2000 · **Joined:** Mon Jan 12, 2004 2:24 am **Posts:** 16

Gavin,
It works. In fact, I've tried in version 2.1.2, and it works as well.
Thanks a lot for that, and thanks a lot for you & friends for giving us such a great stuff!!!

I was wondering, where or in what doc can I find the list of hibernate features like that? Can't find it in the hibernate_reference.pdf.

david · **Posted:** Wed Jun 09, 2004 7:49 pm

Read the source luke.

This is a dialect specific feature - 2.1.4 include more db functions in the various dialects. Its currently not documented.