Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marcdan

    How to get the value of the hour part of datetime

    SQL Server 2008 Enterprise.
  2. marcdan

    How to get the value of the hour part of datetime

    Hi, thanks for your answer. Its exactly, what I have - the only one column with duration time. It's in a database as a filed of type time. During creating a cube, I created new calculated field, which is just this duration converted to a single, so that I could perform calculations on it. And...
  3. marcdan

    How to get the value of the hour part of datetime

    Thank for your response, but unfortunatelly I still can't get it working. Trying get the number of hours using VBA!Hour() function seems not work. Could you paste here a sample usage of the function in that context? Thank in advance Marcin Danek
  4. marcdan

    How to get the value of the hour part of datetime

    Could you tell me, what should I pass as a parameter to that function? The transformation is done in a format_string property, and I have no idea, how to get an unformatted value of the time.
  5. marcdan

    How to get the value of the hour part of datetime

    Hi, I'm trying to calculate the total amount of the calls durations. I managed already to get sum of every call, and I get quite pretty result, for example: 2 days 3:43:23. What I want to get, is to present the result in form: 51:43:23. The way, I get the first result is: CALCULATE; CREATE...

Part and Inventory Search

Back
Top