Calling Stored Procedure for Date Conversion
empyreOct 20 2008 — edited Dec 17 2008
I have a small problem that probably is a simple solution but i am new to OBI and can't seem to figure it out.
All the dates in my DB are stored in binary. In order to 'see' the correct date, i need to do a call to "dbo.udf_pdmtime_to_datetime(order_date)" which converts and returns the field in a date time format.
Now my questions is....where do i do this call to the procedure? In the Administration Tool? In Answers?
How do i go about doing this?