2 Replies Latest reply: Apr 16, 2013 11:25 PM by 997624 RSS

    HOW TO DELETE TIME FROM MY SQL DATE

    997624
      Hello developers,

      I am brand new in OBIEE, in one of my reports the dates are coming as *01/06/2012 12:00:00 AM*. I need to drop the "12:00:00 AM" and leave date as 01/06/2012; my SQL statement is "Begin Transaction Date"."Begin Transaction SQLDate"

      so far I have tried: select cast("Begin Transaction Date"."Begin Transaction SQLDate") as datetime. I keep getting an error


      please please help