Oracle DB Error ORA-01817 day of week may only be specified once

Oracle DB Error ORA-01817 day of week may only be specified once

The following is the cause of this error:

More than one day-of-the-week format code was listed in a date specification. Only one of the following day-of-the-week format codes may be specified in a date: D, DY, DAY.

Action you can take to resolve this issue: Remove all but one day-of-the-week format from the date specification.


Tags: Database, Microsoft, SQL, Oracle, Software, DBMS




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution