Board index Database

error ORA-01855: AM/A.M. or PM/P.M. required

error ORA-01855: AM/A.M. or PM/P.M. required

Post by Fie Fie Nile » Sat, 13 Apr 2002 01:39:48



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.

 
 
 
Top

1. Save time in hh:mm:ss AM/PM format

Hi gurus,
Is it possibleto save data in smalldatetime/datetime field in HH:MM:SS
AM/PM format only without a prefix date mm/dd/yyyy.
I am trying to save time value only in a stored procedure which is
originally a string value and I am casting it to smalldatetime format
before updating it to the table. But SQL by default puts '1/1/1900' in
front of my time. Does it have to do that. I want plain simple time in
my field, what is the way of doing it

thanks

aamir

2. Personal Oracle 7 - Can we create new database

3. check DateTime range btw 8:00 AM and 8:00 PM

4. Text object color changes

5. h:nn AM/PM Format in SQL

6. Debugger Out of Memory: Pdox7 for Win 3.1

7. How to get hh:mm AM(or PM)

8. Ingres migration from VAX to Windows.

9. DTS causes 24hour clock time to change to am/pm and loses or gains 12 hours

10. Convert mm/dd/yyyy hh:mm:ss AM/PM to mm/dd/yyyy format

11. Save time in hh:mm:ss AM/PM format

12. How can i get only the time in am/pm format from datetime field

13. 24 hour time switches to incorrect am/pm time


All times are UTC
Board index