Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Type conversions and Nulls Rate Topic Display Mode Topic Options
Author
 Message
 Posted Tuesday, February 05, 2013 9:55 AM
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 11:05 AM Points: 2,162, Visits: 1,212
 Thanks Tom. After a number of controversial questions and explanations it is great to have one that makes you think and is right on target.+1 Not all gray hairs are Dinosaurs!
Post #1415965
 Posted Tuesday, February 05, 2013 9:59 AM
 SSC Eights! Group: General Forum Members Last Login: 2 days ago @ 8:13 AM Points: 870, Visits: 889
 Please try:declare @k int;select case when @k=0 OR NOT (@k = 0) then cast(0 as date) else cast('2012-04-01T10:00:00' as datetime) end as [when] ;anddeclare @k int;select case when @k=0 OR NOT (@k = 0) then cast('04/01/2012T10:00:00' as date) else cast('2012-04-01T10:00:00' as datetime) end as [when] ; --------------------------------------"Stay Hungry, Stay Foolish." ― Jobs“Everything has beauty, but not everyone sees it.” ― Confucius
Post #1415968
 Posted Tuesday, February 05, 2013 12:32 PM
 SSCommitted Group: General Forum Members Last Login: Friday, December 06, 2013 10:10 AM Points: 1,803, Visits: 10,921
 Great question, TomI almost wish you had thrown in an option of '2012-04-01 10:00:00.000' to spice up the thinking a bit more. Of course, then I probably would have gotten it wrong.... Rob SchripsemaAccelitec, Inc
Post #1416034
 Posted Tuesday, February 05, 2013 1:52 PM
 SSCertifiable Group: General Forum Members Last Login: Yesterday @ 1:48 PM Points: 7,941, Visits: 8,361
 chgn01 (2/5/2013)Please try:declare @k int;select case when @k=0 OR NOT (@k = 0) then cast(0 as date) else cast('2012-04-01T10:00:00' as datetime) end as [when] ;Well, that will fail with an error at cast(0 as date)anddeclare @k int;select case when @k=0 OR NOT (@k = 0) then cast('04/01/2012T10:00:00' as date) else cast('2012-04-01T10:00:00' as datetime) end as [when] ;Well, it seems quite reasonable that cast('2012-04-01T10:00:00' as datetime) should deliver 2012-04-01 10:00:00.000 Tom'S iomadh doigh a th’ air cu a mharbhadh gun a thachdadh le ìme
Post #1416079
 Posted Tuesday, February 05, 2013 4:05 PM
 SSCrazy Group: General Forum Members Last Login: Today @ 12:47 AM Points: 2,829, Visits: 1,764
 Nice question and explanation. Thanks Tom.
Post #1416143
 Posted Tuesday, February 05, 2013 5:54 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Yesterday @ 4:26 PM Points: 582, Visits: 451
 Well, the good news is, I got NULLs down pat. The less good news is, I didn't even stop to think about type precedence. Conclusion - time for more coffee.
Post #1416183
 Posted Tuesday, February 05, 2013 7:10 PM
 SSCommitted Group: General Forum Members Last Login: Tuesday, October 22, 2013 1:39 PM Points: 1,519, Visits: 3,032
 Olga B (2/5/2013)Well, the good news is, I got NULLs down pat. The less good news is, I didn't even stop to think about type precedence. Conclusion - time for more coffee. +1 on that.And as for the collation specification, I figured that was just Tom's QOD signature since most of his contributions that I recall had to do with that.Overall, very good one.
Post #1416204
 Posted Tuesday, February 05, 2013 9:44 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Sunday, December 08, 2013 9:50 PM Points: 522, Visits: 552
 Curse you Precedence!always the one that I forget about, ah well :)
Post #1416230
 Posted Wednesday, February 06, 2013 3:04 AM
 SSC Eights! Group: General Forum Members Last Login: Friday, November 29, 2013 2:12 AM Points: 863, Visits: 1,093
 Easy one for me . “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1416353
 Posted Wednesday, February 06, 2013 7:52 AM
 Hall of Fame Group: General Forum Members Last Login: 2 days ago @ 4:11 AM Points: 3,437, Visits: 72,369
 Good question, thank you for writing it! --Mark Tassin MCITP - SQL Server DBAProud member of the Anti-RBAR alliance.For help with Performance click this linkFor tips on how to post your problems
Post #1416516

 Permissions