Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get "Day of week" from DateTime in HQL?

843859Feb 13 2007 — edited Nov 20 2014
Hi,

I am facing a problem using Hibernate. I am using MS SQL 2000.

I am retrivng some data using HQL. In this data there is a field of data type DataTime. When I retrive data of this field I get date like:
2007-01-06 17:25:10.0

I would like to get "Day of week" for this date in the numeric form or atleast in any form.

Please guide me how is it possible in an HQL, or is there any function for this task?

Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2007
Added on Feb 13 2007
#database-connectivity-discussions
9 comments
2,141 views