Professional Web Applications Themes

How to add the seconds? - Microsoft SQL / MS SQL Server

Do I have this SP that adds the number of hours work of a person (hour and seconds), however don't I know with adding also the seconds... some clue? create procedure dbo.SP_SOMAHORAS with encryption as begin --IT REMOVES THE UNNECESSARY LINES set nocount on declare SomaSegSaida integer, SomaSegEntrada integer, NumHorasTrab integer select SomaSegSaida = sum((datepart(hh, saida) * 3600) + (datepart(mi, saida) * 60) + datepart(ss, saida)) from table1 select SomaSegEntrada = sum((datepart(hh, entrada) * 3600) + (datepart(mi, entrada) * 60) + datepart(ss, entrada)) from table1 set nocount off print SomaSegSaida print SomaSegEntrada set NumHorasTrab = SomaSegSaida - SomaSegEntrada select NumHorasTrab ...

  1. #1

    Default How to add the seconds?

    Do I have this SP that adds the number of hours work of a person (hour and
    seconds), however don't I know with adding also the seconds... some clue?

    create procedure dbo.SP_SOMAHORAS
    with encryption
    as
    begin
    --IT REMOVES THE UNNECESSARY LINES
    set nocount on
    declare SomaSegSaida integer, SomaSegEntrada integer, NumHorasTrab
    integer
    select SomaSegSaida = sum((datepart(hh, saida) * 3600) + (datepart(mi,
    saida) * 60) +
    datepart(ss, saida)) from table1
    select SomaSegEntrada = sum((datepart(hh, entrada) * 3600) + (datepart(mi,
    entrada) * 60) +
    datepart(ss, entrada)) from table1

    set nocount off
    print SomaSegSaida
    print SomaSegEntrada
    set NumHorasTrab = SomaSegSaida - SomaSegEntrada
    select NumHorasTrab / 3600 --horas
    select NumHorasTrab / 60 % 60 --minutos
    end


    Frank Guest

  2. #2

    Default Re: How to add the seconds?

    I am with the following mistake:

    Server: Msg 409, Level 16, State 2, Line 2
    The sum or average aggregate operation cannot take a datetime data type as
    an argument.


    "Tore Bostrup" <newspost_at_bostrup.us> escreveu na mensagem
    news:phx.gbl... [/ref]
    and [/ref]
    clue? 
    > (datepart(mi, 
    >
    >[/ref]


    Frank Guest

  3. #3

    Default Re: How to add the seconds?

    Then combine the two selects, and do it all at once:

    create procedure dbo.SP_SOMAHORAS
    with encryption
    as
    begin
    --IT REMOVES THE UNNECESSARY LINES
    set nocount on

    SELECT
    Sum(DateDiff(hh, entrada, saida)) as Hours,
    Sum(DatePart(mi, saida - entrada)) as Minutes,
    Sum(DatePart(s, saida - entrada)) as Seconds
    FROM table1

    set nocount off
    end

    HTH,
    Tore.


    "Frank Dulk" <com.br> wrote in message
    news:phx.gbl... [/ref]
    do [/ref]
    > and [/ref]
    > clue? [/ref][/ref]
    (datepart(mi, 
    > > (datepart(mi, 
    > >
    > >[/ref]
    >
    >[/ref]


    Tore Guest

Similar Threads

  1. How can I do this every 2 seconds?
    By trints in forum Macromedia Flash Actionscript
    Replies: 8
    Last Post: March 7th, 02:20 AM
  2. seconds to YYYYMMDDHHMMSS
    By Gustavo in forum UNIX Programming
    Replies: 8
    Last Post: November 10th, 11:08 PM
  3. 2 seconds
    By bredd@email.com in forum Ruby
    Replies: 0
    Last Post: August 2nd, 07:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139