View original (French)

System time under Informix

SossAbj -  

Hello

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

6 answers

  1.  jee pee Moderator

    Hello,

    If we look at the documentation, it should be

    select sysdate from dual or select current from dual
    0
    1. 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
      1. jee pee Moderator

        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
        1. 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 Moderator

            Try

             select sysdate from sysmaster:sysdual
            0
        3. 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
          1. SossAbj

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

            0