lundi 13 juillet 2015

Positive values from Datediff without using ABS

CASE 1 = 1 THEN ISNULL(Convert(varchar,DATEDIFF(day, DATE1, DATE2)),'')

I need to have all positive values from the difference, When i use ABS it wont work as Varchar is the type.I need empty string for Null Values.

Aucun commentaire:

Enregistrer un commentaire