Hi, Have a requirement to use datediff function for calculating the difference in days. My generic query should be able to execute both on Oracle and SQL Server. DateDiff is keyword for SQL Server. So how do I write the generic query? What is the best possible option available under such circumstances - where we need to write generic queries?