Error-Missing/Invalid SQL statement'E(3706):Syntax error

Database
Highlighted
SN
Enthusiast

Re: Error-Missing/Invalid SQL statement'E(3706):Syntax error

For DATEPART you can use the EXTRACT and AFAIK there is no direct funtion for date diff, instead you can directly subtract two dates - sel '2008-07-28' - '2008-07-25'. for further date logics you can utilise the TD sys_calendar.calendar view.

thx