ok I found
the mapping shoul be something like this:
<property name="OrderDay" formula="DATEADD(day, DATEDIFF(day, 0,
orderedDate), 0)" type="Int32" />
just another question how can I set read only in the mapping property ?
cheers
2008/10/28 Will Shaver <[EMAIL PROTECTED]>
>
> The easiest way that comes to mind would be to map a read-only
> property to a sql conversion Convert('dd', OrderDate)
>
> <property name="OrderDay" formula="Convert('dd', OrderDate)" type="Int"/>
>
> The Convert('dd' OrderDate) might vary depending on your backing db.
>
> You could then reference OrderDay in your criteria queries.
>
> On Tue, Oct 28, 2008 at 3:40 PM, Mauro <[EMAIL PROTECTED]> wrote:
> >
> > HI
> > I have a question for you monster of nhibernate ;-)
> >
> > I try to make a quey with HQL dialects where I have group by date.
> > I try to explain better:
> > I have a field.. let call it: OrderDate in Order class in this field
> > is stored the date in format like "28/10/2008 15:51:15"
> > How can retrive and group only by DAYS ?
> > as result's example will be like this :
> > (sum) (day)
> > 5 27
> > 13 28
> > 10 29
> > 11 30
> > 9 31
> > 10 1
> > etc..
> >
> > Is it possible ?
> >
> > thanks
> >
> > >
>
> >
>
--
Warning Notice
The information contained in this communication and any documents
transmitted with it are confidential, may be privileged and are intended
solely for the use of the intended recipient. If you are not the addressee
any copying, retransmission, distribution, action taken, or omitted to be
taken in reliance upon it is strictly prohibited and may be unlawful. If you
have received this communication in error please notify us immediately by
e-mail and delete it from your system and destroy any copies of it.
Avviso
Le informazioni contenute in questo messaggio di posta elettronica sono
riservate e confidenziali e ne e' vietata la diffusione in qualunque modo
eseguita.
Qualora Lei non fosse la persona cui il presente messaggio e' destinato, e'
invitata a non diffonderlo, e ad eliminarlo, dandone gentilmente
comunicazione al mittente.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
