Results 1 to 2 of 2

Thread: Get Date??

  1. #1
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    Question Unanswered: Get Date??

    Hi all,

    What is the get date syntax in Informix. In MS SQL it is GetDate() to get the system date, however not sure about informix or if there is one??

    Thanks
    Anthony

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    select today
    from systables
    where tabid = 1;

    OR

    select current
    from systables
    where tabid = 1;

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

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