Post reply

SQL Syntax error using CAST

  • August 2, 2006 at 4:14 pm

    #61693

    Hi All

    I have an SQL that I'm having problems using the CAST function. Below is part of the SQL program:

    SUM(B.Billing_Time) AS Incident_Bill,

    SUM(B.Absorbed_Time) AS Incident_Abs,

    SUM(B.Actual_Time) AS Incident_Actual,

    SUM(E.Billing_time) AS Solmon_Bill

    CAST(SUM(D.Billing_Time)AS decimal(8,2)) As Task_Bill

    SUM(D.Absorbed_Time) as Task_Abs

    Thanks for any help on this issue. The data is stored as "float" and I'd like it to be displayed in 2 decimal places

  • August 3, 2006 at 6:29 am

    #653052

    William

    Could it be the absence of a comma before (and after) the fifth line?

    John

  • August 3, 2006 at 7:27 am

    #653084

    There also appears to be a space missing before AS in line 5.

  • August 3, 2006 at 8:27 am

    #653121

    Thank you all. This list is GREAT!!!

    Bill

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply