Re: Comparing Date - Problem

Tom Miskiewicz wrote:

>Richard,
>
>
>
>>Are you sure the STARTDATE column is a DATE data type? Do a describe on
>>the TEST table.
>>
>>
>
>The application server I'm using shows it as a data, BUT in the database
>it's a number field.
>
>
>Thanks
>Tom
>
>

Well since numbers are not dates you will need to write a function to make the appropriate
conversion.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)