View original (French)

System time under Informix

SossAbj Posted messages 1 Status Member -  
 SossAbj -

Hello

How to retrieve the system time that evolves dynamically under Informix? What query?

6 answers

  1.
    jee pee Posted messages 31883 Registration date   Status Moderator Last intervention   9 979
     

    Hello,

    If we look at the documentation, it should be

    select sysdate from dual or select current from dual
    0
  2. Sossabj
     

    Thank you, I have already tried this formula in an SQL procedure with several steps where I want to calibrate the start and end times. But the same time always appears.

    But the time does not change.

    0
  3. jee pee Posted messages 31883 Registration date   Status Moderator Last intervention   9 979
     

    Do

     select sysdate from dual

    what is displayed and what is the system time? redo the same query 15 minutes later what is displayed

    0
  4. SossAbj
     
     select sysdate from dual

    it does not recognize "dual"

      206: The specified table (dual) is not in the database.
       111: ISAM error:  no record found.
     

    0
    1. jee pee Posted messages 31883 Registration date   Status Moderator Last intervention   9 979
       

      Try

       select sysdate from sysmaster:sysdual
      0
  6. SossAbj
     

    Thank you dear colleague

    This order works in single unit

    I’m trying it in a long-duration script to see the result

    I’ll get back to you...

    0
  7. SossAbj
     

    No change, the script lasted over 15 minutes but start time = end time

    0