Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 638
  • Last Modified:

Convert time to sec

Is there a SQL function that could
to convert, let's say, 15 min to 900 sec.

I have a specific need in which I need my
start and end times represented in
number of secs, vs. hh:mm:ss
0
ivanh
Asked:
ivanh
1 Solution
 
samopalCommented:
select datediff(s,StartDate,EndDate) as DifInSec

HTH
0
 
ivanhAuthor Commented:
Ugh, I foregot about the datediff function....

Thanks.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now