Hello,

I want to select orderlines ordered by date en within the date on ordernumber. But:
select tdsls401.* from tdsls401
order by tdsls401.prdt, tdsls401.orno, tdsls401.pono

this query does not work correct because tdsls401.prdt is an UTC date.
So it orders on date then on time and then on ordernumber.

Is there a way to eliminate the time part of an UTC date.

I want to use Easy SQL, so I can only use select statement.