Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Generate date

Hi All,

I'm using BODI 3.1 and Oracle 11g as my backend, how do I generate date from start of month to end of month in designer as specified below


'2014/10/01 12:00:00' 



'2014/10/31 12:00:00'

Any help would be greatly appreciated.


Former Member

to_char( Date_Generation.DI_GENERATED_DATE,'YYYY/MM/DD)||' 12:00:00'

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question