Results 1 to 2 of 2

Thread: division

  1. #1
    Nils Guest

    Default division

    First of all, I read the FAQ. I am calculating the number of days between 2 dates in my SQL like this:<BR>(round(sysdate - its_pallet.DATE_CREATED)) as DAYS<BR>I am further calculating DAYS into MONTHS like this:<BR>(round((round(sysdate - its_pallet.DATE_CREATED))/ 30)) as MONTHS<BR>Problem is, it is rounding down (like I want it to) for higher numbers (above 200 or so), and rounding up for lower numbers.

  2. #2
    Lurker Guest

    Default RE: division

    Why not use datediff()?

Posting Permissions

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