Re: Year 2000 problem with SQL *Net?

Try using the to_date function. For example:

   INSERT INTO table VALUES ( to_date('12/25/2000','MM/DD/YYYY') );

This way, you can specify the date in any format you want, and by using the appropriate format mask, you can convert it to Oracle's date format.

HTH,
Brian

DistressedCanadian wrote:
>
> I am accessing an Oracle7 Database through SQL *Net. When I run a
> query to get all results between yesterday and christmas, I get results
> from yesterday and today. When I do the same query with an end date of
> christmas 2000, I get no results at all.
>
> We are storing dates in the form 'DD-MMM-YY'
>
> Is there some command to enter to get the date of 00 to be recognized?
> When I try usin '2000' I get an error, so it must be in 2 digit format.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Nov 18 1999 - 07:58:37 CST