char to datetime!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » char to datetime!

17 posts, Page 2 of 2

««1 2

char to datetime!

Rate Topic

Display Mode

Topic Options

Author

Message

Toreador

Posted Wednesday, August 19, 2009 10:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

Cliff Jones (8/19/2009)

Mark Horninger (8/19/2009)

Actually, you could do an implicit or explicit conversion....

I agree. That was my first thought as well.

Me too. Since there was no 'either implicit or explicit' option, I got it right by a 50% guess Smile

Post #773706

GSquared

Posted Wednesday, August 19, 2009 1:32 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

The question doesn't actually ask what the author thinks.

I got it right, but only by trying to outthink the author.

None of the answers given were actually sequitur to the question.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #773866

Rob Goddard

Posted Thursday, August 20, 2009 6:52 AM

SSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 3:48 AM
Points: 660, Visits: 557

GSquared (8/19/2009)

The question doesn't actually ask what the author thinks.

I got it right, but only by trying to outthink the author.

None of the answers given were actually sequitur to the question.

Exactly what I thought when I was staring at the answers, frustrated that I had to take a wild stab in the dark before being able to post... Unfortunately I wasn't successful in my attempt to outthink the author.

--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams

Post #774163

Christopher Stobbs

Posted Monday, August 24, 2009 9:14 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, February 24, 2010 4:10 AM
Points: 1,553, Visits: 2,232

I agree with the last two posts. I got it wrong cause I can't mind read.

I can think of many examples where the cast is not implicit...

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

w00t

Posting Best Practices
Numbers / Tally Tables

SQL-4-Life

Post #776092

L' Eomot Inversé

Posted Wednesday, October 28, 2009 2:09 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:54 AM
Points: 7,086, Visits: 7,138

Christopher Stobbs (8/24/2009)

I agree with the last two posts. I got it wrong cause I can't mind read.

I can think of many examples where the cast is not implicit...

Well, I disagree with those two posts and with you. Is the conversion from tinyint to int implicit, explicit, or forbidden? It's implicit. But as far as I can see you are telling me that because it is perfectly valid to write
declare @integer int
declare @octet tinyint
select @octet = 0
select @integer = cast (@octet as int)
the conversion from tinyint to int is explicit. Well, I think that's a very strange point of view.

The descriptions in BOL seem to me quite clear. In fact there's even a nice matrix showing which conversions are implicit, which explicit, and which forbidden. It's been there since SQL 2000. It's still there in SQL 2008 R2. [url=http://msdn.microsoft.com/en-us/library/ms187928%28SQL.105%29.aspx][/url]

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #810296

rja.carnegie

Posted Thursday, October 29, 2009 7:46 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 16, 2011 5:32 PM
Points: 76, Visits: 151

Incidentally I recently created a view around OPENQUERY() - data coming from a linked server. Which may have been not the best way to do what I was doing. But anyway, I thought it could be useful to name and CAST to type the columns of the OPENQUERY results - that is, to express explicitly outside the OPENQUERY term the expected columns. But is that worthwhile, or does it perhaps even create a problem?

I haven't been doing the problems lately because I realised if I pass on one that's too hard it doesn't count in the game, and my score looks better than it is. Like Who Wants to Be a Millionaire, I can look at the question and decide to ignore it and keep what I've got. Maybe the score system should keep count of that. I mean, I also don't want to guess, particularly on a point I don't currently understand but may need to at a later date.

Post #810764