1. error ORA-01855: AM/A.M. or PM/P.M. required
Our VB 6 program access Oracle database using MS ODBC for Oracle. The
program is trying to run the following SQL stt:
select DATANOTES_NOTES from DATANOTES where EEI_KEY = 654 and DATANOTES_DATE
= TO_DATE('04/11/2002 11:10:45 AM','MM/DD/YYYY HH:MI:SS AM')
The Time Format and Date Format setting in Control Panel - Regional Setting
are the following:
Time Format: HH:mm:ss
Date Format: dd/MM/yyyy
For example: 11/04/2002 14:10:10 for April 11, 2002 2:10:10 PM
On a machine that uses MS Odbc for Oracle version 2.573.6019.00 I got an
error
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01855: AM/A.M. or PM/P.M.
required.
I do not get this error on a machine that uses MS Odbc for Oracle version
2.573.5303.00 or MS Odbc for Oracle version 2.573.7713.00.
Is this a problem with MS Odbc for Oracle version 2.573.6019.00?
Thank you.
2. US - CA, MI, OH, FL - AS400 Developers Needed Now!
3. Busy Day = Slowdown from 12 AM - 5 AM
4. how to use ASP reference a stored procedure in Sybase database?
6. Clarification on altering Next extent size using SAPDBA......
7. I am getting this message when i am tring to export or import anything using
8. I am getting duplicate records, I mean everything is duplicate even Access record number
9. Reading in numbers - am I missing the boat?
10. Record Number in dBase -Delphi 1.0
11. Problems with compiling of DBBrowser demo (Delphi 1.0) in Delphi 2.0 and Delphi 3