tag:blogger.com,1999:blog-8722048993094113071.post5510788652687342904..comments2023-09-11T06:34:38.721-07:00Comments on The world is amazing: Using TRUNC function in JPQLUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8722048993094113071.post-9202833718906354212017-03-29T16:50:52.905-07:002017-03-29T16:50:52.905-07:00God bless you. It does work.God bless you. It does work.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8722048993094113071.post-29581566343745820672015-02-23T14:39:40.347-08:002015-02-23T14:39:40.347-08:00This comment has been removed by the author.sachttps://www.blogger.com/profile/09675932658936137989noreply@blogger.comtag:blogger.com,1999:blog-8722048993094113071.post-33496706200655761052015-02-23T14:38:22.058-08:002015-02-23T14:38:22.058-08:00Its is not taking the second parameter. I am tryin...Its is not taking the second parameter. I am trying to pass 'IW' like this<br /><br />FUNC('TRUNC', o.date, 'IW')<br /><br />It is throwing exception.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8722048993094113071.post-48117707753021261162013-11-19T08:10:58.930-08:002013-11-19T08:10:58.930-08:00You have to notify people that it's only with ...You have to notify people that it's only with JPA 2.1 and as "FUNCTION" done, you just killed my hopes...D.https://www.blogger.com/profile/05754587005374054597noreply@blogger.com