getting rid of decimals

Results 1 to 2 of 2

Thread: getting rid of decimals

  1. #1
    Nils Guest

    Default getting rid of decimals

    I am using "Select abs(sysdate - DATE_CREATED)as DAYS....." to get the number of days between today and a selected date from an Oracle table. And I am displaying it like this:<BR>strDays = objRS("DAYS") <BR>Response.Write "&#060;td&#062;" & strDays & "&#060;/td&#062;&#060;/tr&#062;"<BR>Problem is, instead of displaying 379 for DAYS, I get 379.85576685948473638. I tried using "int" and "fix" to get rid of the decimals, but I got: Variable uses an Automation type not supported in VBScript<BR>

  2. #2
    Nils Guest

    Default no more decimals

    I got it.<BR><BR>(round(sysdate - DATE_CREATED))as DAYS

Posting Permissions

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