Skip to Content
0
Former Member
May 17, 2010 at 08:09 AM

Need help with converting a query to maxDB

255 Views

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