Skip to Content
0

Query not working

Dec 04, 2017 at 07:36 PM

31

avatar image
Former Member
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;
SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers