Skip to Content
avatar image
Former Member

Query not working

SHIP_NAME   DATE_OF_DEPARTURE(DD/MM/YYYY)
   A           15/12/2017
   B           09/12/2017
   c           30/12/2017
   D           29/12/2017

Can anybody figure out any issues with this statement .Its not working .

SELECT T1."SHIP_NAME" AS "Ship Name" , DAYS_BETWEEN (CURRENT_DATE,T1."DATE_OF_DEPARTURE") AS "Days Between" FROM “_SYS_BI”.“M_SHIP_DEPARTURE” as T1;
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers