|
shuda
Starting Member
1 Posts |
 Posted - 08/03/2005 : 14:33:59
|
This simple datediff works fine on sybase:
SELECT DATEDIFF(d, '01/01/2005', '02/01/2005')
However, when I run the query on a DB2 db. I get this error message:
[IBM][CLI Driver][DB2/6000] SQL0206N "D" is not valid in the context where it is used. SQLSTATE=42703
(42S22,-206)
Question: is there different syntax for datediff in DB2 OR should it be the same T-SQL statement? |
|
datediff T-SQL vs. DB2 sql
