SAP BO free hand SQL date formatting issue

[former_member588739]

I have a simple query code (Oracle SQL server)

select * from [table] where DT_CURRENT_DT = '15-OCT-18'

On SQL Developer level everything works fine and query return results.

When creating a Free Hand SQL in SAP BO Universe I get no data...

Is there some way to re-format the date so SAP will recognize it?

[amitrathi239]

try with below format of date.

'2018-11-15'

[former_member588739]

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

Above formula solved the issue