Ansicht
Dokumentation

QRY1460 - Date, time, or timestamp syntax not correct. ( OS/400 )

PERFORM Short Reference   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : QRY1460
Date, time, or timestamp syntax not correct.

Message Long Text :

Cause . . . . . : The date, time, or timestamp syntax is not correct for the format of the date, time, or timestamp. The separators must match the format that is being used.
Examples:
-- DATE1 EQ '1991-02-04' International Standards Organization (ISO) format yyyy-mm-dd
-- DATE2 EQ '02/04/1991' IBM USA Standard (USA) format mm/dd/yyyy
-- DATE3 EQ '04.02.1991' IBM European Standard (EUR) format dd.mm.yyyy
-- DATE4 EQ '1991-02-04' Japanese Industrial standard (JIS) format yyyy-mm-dd
-- DATE5 EQ '91-02-04' yymmdd format with dash date separator
-- DATE6 EQ '02-04-91' mmddyy format with dash date separator
-- DATE7 EQ '04-02-91' ddmmyy format with dash date separator
-- DATE8 EQ '91-035' Julian format with dash date separator
-- TIME1 EQ '12.23.07' International Standards Organization (ISO) format hh.mm.ss
-- TIME2 EQ '12:23 PM' IBM USA Standard (USA) format hh:mm AM or PM
-- TIME3 EQ '12.23.07' IBM European Standard (EUR) format hh.mm.ss
-- TIME4 EQ '12:23:07' Japanese Industrial standard (JIS) format hh:mm:ss
-- TIME5 EQ '12:23:07' hhmmss format with colon time separator
-- TIMSTP EQ '1991-02-04-12.23.07.123456' timestamp format is always the same
Recovery . . . : Type a date, time, or timestamp value. Any SAA date, time, or timestamp format may be used. If an i5/OS date or time format is used, it must match the i5/OS format and separator for the query. Press F17, Constants format, to see the i5/OS date and time formats and separators that are allowed for this query.

Message File : QQRYMSG
Library Message File : QSYS2924


ABAP Short Reference   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3256 Date: 20240427 Time: 021248     sap01-206 ( 3 ms )