Colin Dabritz

Age: 32

I am a Systems Development Engineer at the Business Solutions Group in Corvallis, OR. It is an experiential learning program for students, hosted at Oregon State University.
Jul
15
awarded Necromancer
Jun
4
comment Will apple store accept my custom status bar which will show for a moment in iphone?
This may well have changed, but the current HIG explicitly forbids custom status bars (but hiding is ok): developer.apple.com/library/ios/documentation/UserExperience/… "Don’t create a custom status bar. Users depend on the consistency of the system-provided status bar. Although you might hide the status bar in your app, it’s not appropriate to create custom UI that takes its place."
Mar
29
accepted SQL DATEDIFF coercion differences between databases on same SQL instance?
Mar
24
awarded Yearling
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
This was originally posted in on stackoverflow here: stackoverflow.com/questions/29238048/…
Mar
24
awarded Student
Mar
24
awarded Yearling
Mar
24
answered SQL DATEDIFF coercion differences between databases on same SQL instance?
Mar
24
awarded Scholar
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
This was the answer. So in this case datediff on Compatibility mode (SQL 2005) 90 or earlier fails, as it tries to do a datediff conversion with a datetime, and the date is out the valid range. Testing on (SQL 2008) 100 or later works, probably doing a better (working) conversion internally like datetime2. Thanks so much!
Mar
24
accepted SQL DATEDIFF coercion differences between databases on same SQL instance?
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
Compatibility levels ARE different, nice catch. I'm testing and writing this up now. Thanks for the dd/day tip. I didn't write the code this was extracted from, but it's good to know about for future.
Mar
24
awarded Autobiographer
Mar
24
asked SQL DATEDIFF coercion differences between databases on same SQL instance?
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
Good thought, I'll post it there as well. Thank you.
Mar
24
revised SQL DATEDIFF coercion differences between databases on same SQL instance?
added 345 characters in body
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
DBCC USEROPTIONS shows Dateformat = mdy on both databases. Other settings appear identical. Updating answer with this now.
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
Tanner, that's not what I see as the range FYI. msdn.microsoft.com/en-us/library/ms187819.aspx says the Date Range is: January 1, 1753, through December 31, 9999 for DateTime. I am clear on the point that the 0001 value is definitely out of the range. I want to understand the differences here.
Mar
24
comment SQL DATEDIFF coercion differences between databases on same SQL instance?
Tanner, JamesZ, I'm sure. I converted the dates in the example to ISO format to avoid any such formatting ambiguity. Same behavior. Thanks! Working on next questions now.
Mar
24
revised SQL DATEDIFF coercion differences between databases on same SQL instance?
added 188 characters in body
1 2 3 4 5