I think it's time for all of us to just abandon that thread to MasterBlaster.

I'm not going back any more.

LutzM (2/12/2011)

---

Craig, Lynn:

Even though it might be fun arguing with a person in such a mood from time to time, there usually is a point where the discussion starts running...

Okay, I guess we are The Borg and MasterBlaster refuses to be assimulated.

Please, some one tell me how my 2nd to last post could be considered insulting. I've read...

Nadabadan,

I'm curious what you find insulting about my post? I have reread it and don't see where I called you any names? I pointed out what I believe...

Yes, Tom, yes I did. After reading Brandie's thoughtful response, and MasterBlasters retort, I just had to say something. I know he will now attack me as well,...

Nadabadan,

True, Brandie may not speak for all of us, but her comments are quite valid. I do find your comments and attitude quite insulting, and displays a complete lack...

Depending on how many posts per page you have set.

Well, it always better to have more than one person testing.

The testing I did used actual data at work, so I may not be able reproduce it right away. ...

@jeff - I haven't been able to find anything as of yet, so some of this has to be taken as personal experience. What this means is that people...

ColdCoffee (2/8/2011)

---

mtassin (2/8/2011)

---

Heck I didn't understand what he was doing with the CTEs...

I could, but a better way is to ask you to check out that blog I suggested. Look at the functions provided and see if you can figure out...

lance.kentwell (2/8/2011)

---

I figured it out 🙂

SELECT DATEDIFF(s, '1970-01-01 00:00:00', (SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))))/86400

SELECT DATEDIFF(s, '1970-01-01 00:00:00', (SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,getdate()),0))))/86400

I also added "/86400" on the end to convert the whole tings to...

I come up with something like this:

SELECT DATEDIFF(s, '1970-01-01 00:00:00', dateadd(mm, datediff(mm, 0, GETDATE()) - 1, 0));

lance.kentwell (2/8/2011)

---

ok, first I am using this query to get first day of the previous month:

SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))

Then I take the result and convert it to epoch time suing...

One Saint there...