Hi Folks,

Why can't you use extract(date from mytimestamp) or extract(time from
mytimestamp)? These could work in both dialect 1 and 3. (In dialect 1
they could zero out the date or time portion).

I know you can get around it by using cast(mytimestamp) as date etc
but this doesn't work in dialect 1. Also I would expect extract to be
able to do it, as date and time are both parts of a timestamp.

One other thing regarding extract, it would be nice to be able to
extract the ISO week number.

Regards
Ian Newby