tmssoftware.com

How trunc datetime field to date with Aurelius

BIZ TMS Aurelius
#1

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

#2

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

#3

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.

#4

I would suggest to add .DateOf to the list of SqlProjections. I think is used very often and the Year/Month/Day combination is a little clumsy.

#5

I personally think .DateOf is less portable and less flexible. Year, Month and Date return simple integer values (not dates) and can be used individually (group by year and month, for example).

© tmssoftware.com