Date Difference

Question

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

I have no problem with that, the more people get active here, the better for all. Just keep in mind quantity != quality.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Now why would you think that I may try to bullshit people just to post messages???

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Did I say so?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

I've learned to read between the lines over the years .

I'm glad to help on this forum since I consider than over 75% of what I now know comes from here.

BTW no offense taken.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

I've learned to read between the lines over the years

Then you should learn to read closer. No offense intended.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Henk Schreij SSCarpal Tunnel Points: 4554 More actions · Answer 6

Frank, you wrote:

select

convert(char(8), dateadd( ss ,...

I tried this (always looking at your smart solutions) but got not the right answer.

I think it was a slip of the pen and the solution should be (using mi)

select

convert(char(8),dateadd(mi,datediff(mi,'2005-05-16 15:02:33.347', '2005-05-17 09:23:30.813') ,0),108)