Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132

    Unanswered: convert string to integer

    hi,
    i have a simple question but i cant figure it out.
    i want my result to be in grand summary it.
    but it didnt summarize. i think it sees my result as string and not an integer.

    my code is
    Code:
    format(time_to_sec(SUM(CASE WHEN key_entry_log.time_end > '16:00'
            THEN key_entry_log.adjustment_time ELSE 0 END))/3600,2) as 'ot hours'
    ive tried to search on different forums and also in mysql manual but it seems i cannot find the answer.

    please advice,

    thanks
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you're trying to convert the sum of times to seconds

    try summing the conversion of each time to seconds instead
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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