Viewing 8 posts - 1 through 8 (of 8 total)
You're so right, feeling very silly right now. That's it, no QoD on Friday, my brain obviously has shut down from this week.
May 2, 2008 at 6:23 am
Umm, it may be that my brain is fuzzy on a Fri morning, but isn't Select datename(m,'2008-07-12') = 'July' (in English) which I'm pretty sure doesn't have an "e" in...
May 2, 2008 at 6:15 am
Well, admittedly, I live in a high tech town, so maybe my observations are skewed somewhat. I've had recruiters calling me (unsolicited) at a rate of once/month. All of the...
April 18, 2008 at 6:35 am
Once I determine that the question (as many ppl have pointed out) didn't know the difference between nvarchar and varchar, I treated those two columns as varchar...Unfortunately, I didn't get...
April 9, 2008 at 6:38 am
The reason 1752 dates throw an error, is that it was during this timeperiod that the British empire switched to the Gregorian calendar. During 1752 there was no Sept 3-13th....
April 4, 2008 at 6:03 am
I had gathered that what you hoped was that you could remove the 00:00:00.000 from the result, but as I stated, with a datetime data type, you'll always get the...
February 6, 2008 at 8:15 am
That'd be because the data type is dateTIME.
If you want just date, convert to SQL 2K8 and use a date only datatype, or as previous example above have done,...
February 6, 2008 at 7:13 am
I used the Cast/Floor/Cast method myself, although often it's just Floor/Cast, since integers are implicitly converted to datetime. (For this reason, on some tables, I store an int for date...
February 5, 2008 at 6:35 am
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy