mizan700 (8/3/2016)

---

Hi Experts,

How can i run my stored procedure inside select statement?

example:

Select Username, exec @myproc from userinfo

Regards,

Mizan

ben.brugman (7/21/2016)

---

spaghettidba (7/21/2016)

---

Dates have no format when they are stored in the database

Dates definitively have a format when they are stored in the database.

ben.brugman (7/21/2016)

---

spaghettidba (7/21/2016)

---

Dates have no format when they are stored in the database

Dates definitively have a format when they are stored in the database.

yujinagata72 (8/1/2016)

---

Hi,

I use the below code, I can get the duration as hh:mm:ss.0000000.

CONVERT(TIME, DATEADD(SECOND, DATEDIFF(SECOND, last_request_end_time, GETDATE()), 0), 114) AS Duration

But how I can get the format like dd:hh:mm:ss?

Thanks,

Eirikur Eiriksson (8/2/2016)

---

Quick thought, datetime does not have any time zone awareness and only assumes UTC, convert into a time zone aware data type such as datetime2 instead.

😎

SELECT CONVERT(DATETIME2,'2016-08-01T07:04:24+01:00',127)

Scubba-Steve (8/1/2016)

---

Actually I am on 2008. I just asked the question on the first SQL forum that I found. Did I post in the wrong place?

Scubba-Steve (8/1/2016)

---

Wow. I didnt catch that. Thanks for the help. Works like a charm.