Hello,
I'm experienced in SQL Server however not yet familiar with the MaxDB functions very well.
I need to convert the following WHERE clause in a query to one that can run on MaxDB:
WHERE DATEADD(MILLISECOND, Timestamp, '19000101') >= DATEADD(YEAR, DATEDIFF(YEAR, '19000101', DATEADD(DAY, -10, GETDATE())), '19000101') AND DATEADD(MILLISECOND, Timestamp, '19000101') < DATEADD(DAY, -9, DATEADD(DAY, DATEDIFF(DAY, '19000101', GETDATE()), '19000101'))
Rgds,
Roy