Helen Borrie wrote:

> cast ('5/1/2005' || ' ' || '10:00:00.0000' as timestamp)
>
> If you do only want a DATE type:
>
> cast ('5/1/2005' as date)

DATE data type (dialect 1)?

I get a date and time with dialect 1 ( yes I know I should switch 10
years worth of stuff to dialect 3 ;) )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services