IDT date format on connection level (oracle)

[former_member588739]

When running below query on SQL Developer it works fine:

select * from [table_name] where DATE = '15-OCT-18'

But when running sql on connection level in IDT or free hand SQL in BO I get no results.

Only below reformatting worked:

to_date('10/15/18', 'MM/DD/YY')

I would like to understand how to check how IDT is formatting date to MM/DD/YY format because when I ran freehand SQL on BO level (with different filter) I got date with that format.

[amitrathi239]

Please select "SAP BusinessObjects -Semantic Layer" tag for universe related queries.

[Joe_Peters · Accepted solution]

BO makes a call to Oracle to set the session date format to "DD-MM-YYYY HH24:MI:SS". So if you manually enter a date condition, it needs to be in this format.