Hibernate Community • View topic - Question: "group by date"

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Question: "group by date"

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

sunyitao

Post subject: Question: "group by date"

Posted: Sat Sep 27, 2003 3:13 am

Newbie

Joined: Sat Sep 27, 2003 3:03 am
Posts: 1

I wanna write a Query like :

" select user,sum(income),to_char(dt,"YYYY-MM-DD") from table group by user,to_char(dt,"YYYY-MM-DD");"

dt is date&time type in DB.

How can i write this query in Hibernate?

Top

david

Post subject:

Posted: Sat Sep 27, 2003 6:30 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

Hibernate supports dialect select functions though at this point multiple argument functions are not supported, eg the first to_char will not be accepted by the select parser. This is on my TODO list but I am not sure exactly when I will add it.

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