CAST DATE computation to Decimal

• Express12

  SSCoach

  Points: 18514

  More actions

  September 20, 2006 at 7:31 am

  #170280

  In my Sybase world, I'm trying to generate a decimal value for the following SELECT statement:

  sum(datediff (hh,DateCol_1, DateCol_2))/ 31

  This works in SQL Server:

  select cast(sum(datediff (hh,DateCol_1, DateCol_2))/ 31 as decimal (18,9))

  It is not working in Sybase.. Is there a CONVERT fucntion I cantry?

  BT

• Express12

  SSCoach

  Points: 18514

  More actions

  September 20, 2006 at 7:56 am

  #661493

  convert(decimal (5,2),(sum( datediff (hh,DateCompletedByResearch, ReadyOrShippedByFulfillment))/ 31))

  BT