Community Member Profile
Bruce Hendry
Member since Mar 8, 2011
- Profile: /members/7951-Bruce-Hendry.htm
- URL: www.binya.com
- Comments: 1
- Points: 10
Recent Blog Comments By Bruce Hendry
-
Careful When Trying To CAST DATETIME AS INT
Posted on Mar 8, 2011 at 7:32 PM
Not sure of the performance ramifications of the following, but I came across some code that was doing this. At first I thought it was wrong until I realized sql was implicitly converting the PayEndDate to an integer. After some testing it appears to work consistently. Apparently DATEDIFF does th... read more »
