2 Replies Latest reply on Dec 27, 2015 10:30 AM by Christian Berg

    Pls help me how to implement below SQL in obiee using DB functions

    2678509
      1. CASE 
      2.   WHEN LENGTH(ACTION_DATE) = 18 THEN TO_DATE(ACTION_DATE, 'DD-MON-YY HH24:MI:SS'
      3.   WHEN LENGTH(ACTION_DATE) = 19 THEN TO_DATE(ACTION_DATE, 'YYYY-MM-DD HH24:MI:SS'
      4.   WHEN LENGTH(ACTION_DATE) = 20 THEN TO_DATE(ACTION_DATE, 'DD-MON-YYYY HH24:MI:SS'
      5. END;