4 digit year problem with timestamp over ODBC

From: Vincent <v_c_at_yahoo.com>
Date: 12 Feb 2004 01:01:15 -0800
Message-ID: <23edd8ed.0402120004.223570b8@posting.google.com>

Hello,

When I issue the following in the Oracle ODBC Test tool: update test1 set field3 = {ts '1900-04-03 00:00:00.000'}

I get the following in the Oracle table (8.1.7) select field3 from test1
02-MAY-00 If I translate the year, it's actually
select to_char(to_date(field3),'dd-mon-yyyy') from test1 02-may-2000

So apparently it didn't receive the year as 1900 and assumed 2000 by just getting 00.

Please let me know how I can convince Oracle to take the correct 4 digit year.

Thanks,

Vincent Received on Thu Feb 12 2004 - 03:01:15 CST