0 Replies Latest reply: Nov 22, 2012 6:42 PM by 438932 RSS

    Getting error in Timestamp calculation formula

    438932
      Hi Guys,

      I am getting error : Invalid Alias Format : Table_name.Column_name required.

      cast(floor(TimestampDiff(SQL_TSI_MINUTE,"Job"."Start Time","Job"."Finish Time" ) / (24 * 60)) as VARCHAR ( 8 )) || ' Days' || ' ' ||
      cast(floor(TimestampDiff(SQL_TSI_MINUTE, "Job"."Start Time","Job"."Finish Time" ) / 60) - floor(TimestampDiff(SQL_TSI_MINUTE,
      "Job"."Start Time","Job"."Finish Time" ) / (24 * 60) * 24 as VARCHAR ( 8 )) || ' Hours ' || cast(floor(TimestampDiff(SQL_TSI_SECOND,
      "Job"."Start Time","Job"."Finish Time" ) / 60) - floor(TimestampDiff(SQL_TSI_MINUTE, "Job"."Start Time","Job"."Finish Time" ) / 60) * 60
      as VARCHAR ( 8 )) || ' Minutes ' || cast(TimestampDiff(SQL_TSI_SECOND, "Job"."Start Time","Job"."Finish Time" ) -
      floor(TimestampDiff(SQL_TSI_SECOND, "Job"."Start Time","Job"."Finish Time" ) / 60) * 60 as VARCHAR ( 8 )) || ' Seconds'

      Any help would be appreciated !