How trunc datetime field to date with Aurelius

[Ricardi_Gustavo]

Hi, I need get a field TDateTime datatype as TDate only. I'm using GraphQL with Aurelius and I needing group by as TDate.

Thanks.

Esteban

[Ricardi_Gustavo]

I found that SQL standard is supported using cast, but I don't know as do it with Aurelius using TCriteria. Is there something similar to cast for use in Aurelius with TCriteria ?

Thanks.

Esteban

[wlandgraf (Wagner Landgraf)]

@Ricardi_Gustavo

Is there something similar to cast for use in Aurelius with TCriteria ?

Not built-in, but you can always create your own functions then use the SqlFunction projection.

However, I would suggest what I consider a simpler way, if you just want to group, use Year, Month and Day projections, and group by then in that order.