If you mean with datediff different number of dates between two dates then yes: select cast('2012-01-01' as date) - cast('2012-01-02' as date); +----------------------+ | sql_sub_single_value | +======================+ | -1 | +----------------------+ 1 tuple (1.111ms) sql>select cast('2012-01-01' as date) - cast('2012-02-02' as date); +----------------------+ | sql_sub_single_value | +======================+ | -32 | +----------------------+ 1 tuple (0.352ms) sql>select cast('2012-01-01' as timestamp) - cast('2012-01-02' as timestamp); +----------------------+ | sql_sub_single_value | +======================+ | -86400000 | +----------------------+ 1 tuple (0.820ms) (thats in ms, because that is the finest gradunalarity) Stefan