Hi guys,
I got a Problem with this Statement:
select distinct (machineid), jobid, valid_from, DATE_ADD('1980-01-01 00:00:000', INTERVAL last_modified SECOND)
from dsstaff
where clientno = '01' and whole_day = 'n' and invalid_from <= '2100-02-01' order by machineid, jobid, valid_from DESC, DATE_ADD('1980-01-01 00:00:000', INTERVAL last_modified SECOND)
I check now many possible Options, but I dont have an AS in my query, nor do I have a ORDER BY in a subquery as stated in many different sources as the issue of this exception. The Problem is possibly the DATE_ADD function, but I dont see a mistake in it last_modified is a value that is added to 1980-01-01.
Would really appreciate if someone could have a look on it.
Thanks a lot in advance.