SQL Expression syntax DateDiff 1

[ksaab2002]

I know this topic has had a lot of coverage so if I am re-iterating forgive me. I have tried solutions from other threads with no result..

I am using CR9 - I am trying to create a SQL expression that finds the difference in days between two datetime fields..I am getting errors and think it is due to syntax. Any suggestions appreciated!

Thanks!

 

[kskid]

Since you specifically said SQL expression, I take it that datediff is out of the question. However, you did not mention what database you are using. The following SQL expression should work in Oracle.

(to_date({table.date1})-round({table.date2})

Cheers,
-LW

 

[vidru]

When using SQL Expressions, the type of database will determine the syntax, but usually, the arguments are:

DateDiff(IntervalType, StartDate, EndDate)

For instance, if using SQL Server, and you want the difference in minutes, the SQL Expression would be:

DATEDIFF(MINUTE, Table.Date1, Table.Date2)

-dave

 

[ksaab2002]

I thought so, I was getting an error but it has resolved. Thanks !