Oracle date math

Results 1 to 2 of 2

Thread: Oracle date math

  1. #1
    Nils Guest

    Default Oracle date math

    How can I display the number of days between today and an entry in a date field in an oracle table?

  2. #2
    Nils Guest

    Default Funky results

    OK- I&#039;m using abs(sysdate - its_pallet.DATE_CREATED) as DAYS in my SQL and Response.Write "&#060;td&#062;" & objRS("DAYS") & "&#060;/td&#062;&#060;/tr&#062;"<BR>for my display.<BR>Why am I getting 379.68202546296296296296296296 as my number of days? 379 is correct, but how do I get rid of all the decimals?

Posting Permissions

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