It's easy to use even if you're a complete beginner.

Let's take a look at the top 10 reasons why Quest TOAD should be your go-to for database development! It is a powerful tool that can help you do your job more efficiently and create better code. So in a GUI if you select date, length(date) the results of the two can have nothing to do with each other, in sqlplus on the other hand they'll always correspond.įor the record PL/SQL Developer displays that date correctly as well.Many Oracle developers are choosing Quest TOAD for their database development software.

So for that the date will be implicitly converted to a char using the nls_date_format. However it's rather meaningless in this case since length only accepts char parameters. The length works of course because it outputs as number. TOAD displays dates as calender objects in the data grid - that was probably never coded to go as high as 5249.

The problem in this case is presumably due to the client code being unable to handle the particular year in this case. So no implicit conversion happens and the nls_date_format is not applied. When you select a date in TOAD for example it's fetched as a date into a date variable in the client (toad) code. Most GUIs can handle dates as dates though. SQLPlus always converts dates to strings when you select them since it's a simple text interface and can't handle dates as dates. The nls_date_format kicks in when converting a date to a string, either implicity or explicity without a format mask. I doubt that that is the problem, I also doubt it's anything really to do with the nls_date_format.

Toad database query tool