Date filtering in data grid

Toad for Oracle
1

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

2

Hi Rainer,

There are several places where a filter can be set. Can you post a screen shot please?

Thanks.

-John

3

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

shot1
shot1769×419 10.8 KB

shot2
shot3
shot3794×195 3.49 KB

4

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

5

That sounds very good :+1:t2: :+1:t2: :+1:t2: