Oracle ODBC driver 8.0 - Date parameters problem.
From: Tcc <syner_at_pd.jaring.my>
Date: Thu, 13 Apr 2000 12:47:00 +0100
Message-ID: <8d3j8u$mn8$1_at_news5.jaring.my>
[Quoted] I'm using MS-Query to connect my Oracle Server 8.0.5 with the ODBC driver 8.0. I add a parameter for a date fields. So if I press the refresh button, a window will prompt out and ask for entering a parameter. After I enter the parameter, the oracle server return message 'ORA-01843: Not a valid month'. I enter the parameter as:
Date: Thu, 13 Apr 2000 12:47:00 +0100
Message-ID: <8d3j8u$mn8$1_at_news5.jaring.my>
[Quoted] I'm using MS-Query to connect my Oracle Server 8.0.5 with the ODBC driver 8.0. I add a parameter for a date fields. So if I press the refresh button, a window will prompt out and ask for entering a parameter. After I enter the parameter, the oracle server return message 'ORA-01843: Not a valid month'. I enter the parameter as:
15-03-2000; 15-APR-00; 2000-02-18; 2000-03-27 00:00:00; '13-APR-00'; So what is the parameter format that I should use? Is that need to add some string or need to modify the values that enter?
Thank for any one who try to help me. Received on Thu Apr 13 2000 - 13:47:00 CEST