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 5, 2013 9:55 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, January 26, 2016 9:10 AM Points: 2,602, Visits: 1,694
 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 5, 2013 9:59 AM
 SSCommitted Group: General Forum Members Last Login: Today @ 10:05 AM Points: 1,617, Visits: 1,728
 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] ; --------------------------------------“Everything has beauty, but not everyone sees it.” ― Confucius
Post #1415968
 Posted Tuesday, February 5, 2013 12:32 PM
 SSCrazy Group: General Forum Members Last Login: Thursday, July 14, 2016 10:57 AM Points: 2,263, Visits: 11,042
 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 SchripsemaPropack, Inc.
Post #1416034
 Posted Tuesday, February 5, 2013 1:52 PM
 SSCrazy Eights Group: General Forum Members Last Login: Today @ 9:19 AM Points: 9,822, Visits: 11,891
 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
Post #1416079
 Posted Tuesday, February 5, 2013 4:05 PM
 SSCarpal Tunnel Group: General Forum Members Last Login: Today @ 10:20 AM Points: 4,131, Visits: 2,324
 Nice question and explanation. Thanks Tom.
Post #1416143
 Posted Tuesday, February 5, 2013 5:54 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Thursday, April 21, 2016 3:45 PM Points: 586, Visits: 455
 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 5, 2013 7:10 PM
 Ten Centuries Group: General Forum Members Last Login: Monday, June 6, 2016 1:51 PM Points: 1,400, Visits: 3,059
 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 5, 2013 9:44 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Sunday, June 14, 2015 6:49 PM Points: 526, Visits: 561
 Curse you Precedence!always the one that I forget about, ah well :)
Post #1416230
 Posted Wednesday, February 6, 2013 3:04 AM
 SSC Eights! Group: General Forum Members Last Login: Tuesday, November 8, 2016 7:26 AM Points: 989, Visits: 1,221
 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 6, 2013 7:52 AM
 Hall of Fame Group: General Forum Members Last Login: Friday, September 16, 2016 12:22 PM Points: 3,849, Visits: 72,507
 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