Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the
very best for you and your families for the new year.
Interested to know about a next post? You can suscribe to my RSS feed HOW TO:
Those of you developing applications that utilize Oracle Databases, might have face the ORA-01843 Not a valid month error. This is a major problem because most of us develop applications that use dates as part of their WHERE clause.
Solution : Before executing any SQL statement though code, you must execute the following SQL statement :
ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'
Note that date format may vary depending on your location. This directive for example is used in Greece.
Name: John Galanopoulos Home: The NeverLands About Me: A source code wonderer since the early 80s with my first ZX81 by Sinclair, home computer. See my complete profile
Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the
very best for you and your families for the new year.
Great tip! New to Oracle SQL and wasting a lot of time on simple stuff.
Your post just cleared my headache better than ibuprofen!!!!!
Thanks for the POST. I am sure I will use it in the future.
BFL