User Profile

Collapse

Profile Sidebar

Collapse
asurratt
asurratt
Last Activity: Oct 13 '06, 07:57 PM
Joined: Oct 13 '06
Location: Chicagoland, IL
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • asurratt
    replied to (datediff(ss,,) / 60) rounding down the minute
    in SQL Server
    Hi again,

    Ok, I was able to resolve the problem. Here's the solution for anyone else who may come across this...



    My original snippet from the update statement to convert seconds to minutes was:
    load_duration = datediff(ss, last_load_start , getdate()) / 60


    Let's say the duration was 2.73 minutes. The above would only return 2.0 minutes.




    When I change the...
    See more | Go to post

      Leave a comment:

    • asurratt
      replied to (datediff(ss,,) / 60) rounding down the minute
      in SQL Server
      Hi,

      Just to clarify...

      I meant to say that the calculation of:
      datediff() / 60
      is not returning the result as I'd expect of x.y....it's returning in x.0

      Thanks!
      See more | Go to post

        Leave a comment:

      • asurratt
        started a topic (datediff(ss,,) / 60) rounding down the minute
        in SQL Server

        (datediff(ss,,) / 60) rounding down the minute

        Hi,

        I have (2) CMD statements that are used to log when a table starts loading in the database with our automated BCP process and another that will log when it completes and determine the duration between.

        But...I'm having problems using datediff() to convert the duration calculated in seconds to minutes.

        Here's the code snippet used to create the 1st log record:

        update TABLE_LOAD_TRAC KING...
        See more | Go to post
        No activity results to display
        Show More
        Working...