Friends....A little study saying... We can use 2 new HQL functions as: DateSum(dateValue, year, month, day): example DateSum(dateValue, 0, 1, 0) DateTimeSum.... bla bla
and attach only the translation for each RDBMS is not so BIG work especially when you (Dimitry) was the one insisting for a Multi-RDBMS solution. The proposal can be even exactly the same syntax of MsSQL and then send the translation for the others dialects where available. 2009/6/4 Dmitiry Nagirnyak <[email protected]> > Hi Fabio, > > >> Try to study a similar solution using DateAdd for each dialect. A simple >> math operation is not viable in this case (as not was viable even for >> Microsoft MsSQL). >> > > I hope I'll be able to do that in a month or so as I have got a lot of work > and couple of projects to finish. > > But we start from the following topics to get started: > - MsSql - http://msdn.microsoft.com/en-us/library/aa258267(SQL.80).aspx > - MySql - > http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add > - PostgressSql - > http://www.postgresql.org/docs/7.3/static/functions-datetime.html > - Oracle - http://www.psoug.org/reference/date_func.html > > Andrew, as you need it at the moment, maybe you'll be able to do this part > please? > Sorry that I'm stepping back on it. > > Cheers. > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
