That only tells you the versions of the client tools etc installed on your machine, not the version of the database engine.

Run this in a query window:

SELECT @@VERSION

Ah-ha! Good point Jeff. But he did mention 2008 in an earlier post.

You may find this useful too:

http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/[/url]

Hi,

Seems to work ok for me.

Try removing whitespace after pasting the code, occasionally I've found odd (non-display) characters in code pasted from the forums.

Another, usually faster, way of splitting a string is with a Tally (or numbers table) see Jeff Moden's article in my signature below.

Take a look at the method about three...

thisisfutile (1/27/2011)

---

nigel. (1/27/2011)

---

Thanks Jeff, nice article.

Spotted a minor typo in the first code example, has SliceDate instead of SliceData for the column alias.

I know it has no real...

Thanks Jeff, nice article.

Spotted a minor typo in the first code example, has SliceDate instead of SliceData for the column alias.

I know it has no real effect. But,...

Couldn't agree more. Thanks Jeff, when's the next one? 😀

Oh, if only I had seen these articles the first time round, so much blood, sweat and tears would have been saved (especially the latter).

Thank you Gail, excellent articles. I...

I think this should cope with the language issues:

SELECT SUBSTRING(CONVERT(CHAR(13),SomeDate,106),4,13)

FROM dbo.JBMTest

Is marginally slower than Jeffs original solution (on my box), but seems to cope with short...

An alternative (simply a refactor):

DECLARE @v-2 VARCHAR(1000)

SET @v-2 = '2,22,5,1,88,2000,7897,800'

SELECT CAST( x.query('fn:min(number)') AS varchar),

CAST( x.query('fn:max(number)') AS varchar),

...

David McKinney (1/20/2011)

---

Très bien, Jeff! Except of course that you can't keep everybody happy!

In France, June and July are Juin and Juillet respectively, and hence JUI and JUI when...

Try this: http://msdn.microsoft.com/en-us/library/system.globalization.datetimeformatinfo.monthnames.aspx

If you're doing this in ASP.NET why go to the database at all, why not do it in the page itself?

That would be the more usual way of doing this,...

Steve (and all),

There's a newer version...