ra8009 wrote:

> Where MYDATE is a timestamp field, I want to display the number of
> days since a given date:
>
> SELECT CAST(CAST('TODAY' as DATE)-CAST(MYDATE as DATE) FROM MYTABLE
>
> However, this gives me an integer. When I try to cast it as a DATE I
> get an error message:

Number of days IS an integer - what did you expect?


Magnus