In reading the datediff docs, I expected that if the difference isn't an hour, there would be truncation, however what I observed is that the result is dependent on the time of day of the values. select datediff( hour, dateadd( hour, 1, '2013-10-30 0...

In the example below, column ver_ts is passed to a builtin function that expects a string argument. This results in a casting error Could not execute statement. Cannot convert timestamp to a long binary SQLCODE=-157, ODBC 3 State="07006" I would h...