Skip to Main Content

Calling Stored Procedure for Date Conversion

empyreOct 20 2008 — edited Dec 17 2008
Hi All,

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?