SAP BO Freehand SQL date formatting (Oracle db)
0
votes
1
answer
569
views
My original query worked perfectly via SQL Developer:
select * from [table] where DT_CURRENT_DT = '15-OCT-18'
However when ran via freehand SQL in SAP BO I got no results.
After running the query with no conditions I noticed that BO re-formats the date to 10/15/18
Asked by marcin2x4
(145 rep)
Nov 16, 2018, 08:10 AM
Last activity: Jan 27, 2025, 03:08 AM
Last activity: Jan 27, 2025, 03:08 AM