How to count the number of days between two dates?

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Thu, 13 Nov 2008 9:48 am

Hi, I need to count the number of days between two dates. Which function to use to give me the difference in number of days?

Regards, Andrew.
lopes_andre
Location: Lisboa

Poston Thu, 13 Nov 2008 10:50 am

SELECT TO_DATE (' 20080101 ', ' yyyymmdd ')-TRUNC (SYSDATE) FROM DUAL OS do the subtraction normal of them ... would that be?
manoel872
Location: Uberlândia - MG

Poston Fri, 14 Nov 2008 6:53 am

Since already thank you for the info manoel872.

Regards, Andrew.
lopes_andre
Location: Lisboa


  • See also
    Replies
    Views
    Last Post


Return to PL/SQL

Who is online

Users browsing this forum: Google [Bot], Google Adsense [Bot] and 15 guests