Hibernate Community • View topic - How to retrieve data about date and time?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to retrieve data about date and time?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

fancyerIII

Post subject: How to retrieve data about date and time?

Posted: Sun Aug 01, 2004 5:58 am

Newbie

Joined: Sun Aug 01, 2004 5:43 am
Posts: 1

In SQL Statement, we can use some date and time function that are different in different database system. For example, in SQL Server 2000,
datediff and dateadd.
I can use a SQL in hibernate but if I do like that My codes can't be applied to different database. The purpose of hibernate is to make the databases no difference in java developers' eyes. So I think it should encapsulate this just like it user Expression class to encapsulate some
query condition such as eq, like. But I can't know how to deal with query
about date and time. Help!
Thank you.

Top

shl

Post subject:

Posted: Mon Aug 02, 2004 3:13 am

Expert

Joined: Fri Feb 06, 2004 7:49 am
Posts: 255
Location: Moscow, Russia

What date and time functions do you need? If you are talked about date/time formatting functions, use following approach:

Code:

List result = session.createQuery("from MyClass obj where obj.someDate > ?")
    .setParameter(0, new Date(), Hibernate.DATE)
    .list();

you also could use Hibernate.TIME and Hibernate.TIMESTAMP.
So you don't need any date/time formatting fuctions :)

--
Leonid

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum