Search code examples
sql-serveroraclessasodac

SQL expression cause ORA 00936 Missing Expression Error

I'm trying to add a named calculation field in ssas project, the following expression works with sql server datasource not with an oracle one :

convert(datetime,convert(date,DATE_HR_INSC),110)

Thank you!

Solution

  • I guess you would like to convert your date value into string using format 110, which means mm-dd-yyyy (12-30-2019).

    The way to do it in oracle is:

    to_char(date,'mm-dd-yyyy')