>I expected a casting support for date/datetime to numerical values.
>
>

>? CAST(DATE() AS I) && Expected the number of days
>                    && from one given conventional date ( {^1900/1/1} is good )
>*that is
>? CAST(DATE() AS I)=(DATE() - {^1900/1/1}) && expected true
>? CAST(DATETIME() AS B(0)) && Expected the number of seconds
>                           && from one given conventional datetime ( {^1900/1/1:} )
>*that is
>? CAST(DATETIME() AS B(0))=(DATETIME() - {^1900/1/1:}) && expected true
>

It's listed in the help file as not supported.