Hi all,
when I create a filter on a date field in the data grid and use the [...] button to select a date from the table data, the filter is always created in the American date format. Is there a possibility to create such a filter in the format that is defined in the TOAD options?
Best regards,
-Rainer
Hi Rainer,
There are several places where a filter can be set. Can you post a screen shot please?
Thanks.
-John
Hi John,
as you can see in screenshot1, I have set the date format in the TOAD options to dd.mm.yyyy like it is usual in Germany. Now I select a data row, and wht I get then ist the filter in the American format, as on screenshots 2 and 3.
And what I would like to have (if somehow possible) is a filter like
ABRECHNUNG = TO_DATE('30.04.2009 00:00:00', 'dd.mm.yyyy hh24:mi:ss')
Best regards,
-Rainer
Oh, I see what you mean. You want the to_date expression to be in the same format as your grid settings.
We have some code in "Export Dataset" that creates the insert statements that way. I'll see if I can generalize that code and use it here too.
-John
That sounds very good 
