Paul Dow wrote:

> As of ASE 12.5.1, then the date type
> is available, so you can do a convert to that which
> would also seem to be what you are after, i.e.
>
> convert( date, date_time_col )

great, that's exactly what I was looking for (working with 12.5.2).

Thanks,
Bernd