Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    20

    Unanswered: SysDate equivalent in Informix

    When I am inserting current system date in a record using sysdate, I use SysDate function. What would I use in the statement below for informix:

    insert into mytable (SysDate,'Me');

    ANy help will be appreciated.

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    you can use 'today' (date columns) or 'current'
    for datetime columns.

    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
  •