On Fri, Mar 25, 2005 at 12:53:53 -0800, Steve Crawford <scrawford@pinpointresearch.com> wrote:
>
> 2) If so, what is the replacement?
You should be able to use EXTRACT, some math to do your own formatting.
For common operations you can define SQL functions to do what you want.
Having to_char(interval) may be more convenient (if it does what you
want), but you can get by without it.