HELP.... DATEDIFF function for INFORMIX. THX.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: HELP.... DATEDIFF function for INFORMIX. THX.

  1. #1
    Juan Alfredo Guest

    HELP.... DATEDIFF function for INFORMIX. THX.


    I need use the function datediff for informix. Please, one example.

    THX.

  2. #2
    gingishan Guest

    Re: HELP.... DATEDIFF function for INFORMIX. THX.


    "Juan Alfredo" <jasantos@asnc.sas.junta-andalucia.es> wrote:
    >
    >I need use the function datediff for informix. Please, one example.
    >
    >THX.




    DEFINE DATE1 DATE;
    DEFINE DATE2 DATE;

    LET DATE1 = TODAY;
    --MINUS 1 MONTH
    LET DATE2 = DATE1 - INTERVAL(1) MONTH TO MONTH;
    --MINUS 1 YEAR
    LET DATE2 = DATE1 - INTERVAL(1) YEAR TO YEAR;




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center