Compare:

DECLARE @date DATE = '20121202';

SELECT

CASE WHEN datename(dw,@date) <> 'Sunday' THEN CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0, @date), 0),

103) ELSE CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0, @date), - 7), 103) END

go

DECLARE @date DATE...

True, but YYYY-MM-DD doesn't always work depending...

You weren't asking how to convert an INT to TIME, this was your...

The quarter final games this week see the SSC Steelers facing off with the SELECT Wins INTO. Having just played each other, what changes will they make going into...

Well, we know who is moving on to the Championship round.

It has been an exciting run. Who will win the championship this year?

As Ray indicated earlier, (DT_DBDATE)0 evaluates to 1899-12-30. This would be equivalent to using -2 inplace of 0 in the T-SQL calls as shown here:

/*

Date Available in db ...

Duplicate post.

Duplicate post.

dogramone (12/3/2012)

---

And unfortunately none of them are intelligent enough to investigate. Oh for the good old days when IT was a black box that no one got involved in...

sap0698 (12/3/2012)

---

Hello,

I'm doing text mining using Oracle SQL Developer: ODMiner.. I imported the data "WEBLOG" into a table.. This weblog data consist of users activity, date, time, url, etc. The...

Jeff Moden (12/3/2012)

---

Stefan Krzywicki (12/3/2012)

---

In my experience, the period from just before Thanksgiving through New Year's Day isn't...

sqlfriends (12/3/2012)

---

I have a SQl SERVER that has a default instance and a named instance.

Do I have to configure the named instance to use diffrent port than 1433 because the...

CELKO (12/3/2012)

---

And most of them have never see a punch card...

var05 (12/3/2012)

---

Hi All,

I wanted to find the starting of the week and poulate it as an additional column. Im trying to use dervived column in SSIS

SQL Equivalent is:

SELECT DATEADD(WK, DATEDIFF(WK,0,'11/01/2012'),...

Care to answer all the other questions I asked? I really don't feel like retyping them.