Re: ODBC timestamp troubles...
Fabio Maccheroni wrote:
}
} ODBC timestamp troubles...
}
} We are working on an ODBC application, and we are facing the following
} problem:
}
} how can we translate the SQL expression
}
} INSERT INTO TABLE1 (NAME,HOUR)
} VALUES ('Jack', CURRENT TIMESTAMP);
}
} used to insert in a DB2 database the name of a guy and the timestamp of
} insertion, for an ODBC driver.
}
} In other words:
} Is there a function that tells an ODBC driver:"PLEASE Get the database
} date"?
} What is it?
}
} Thank you!
}
} Fabio
I assume the database is Informix. You could use the following to get
that:
insert into tables (name, hour) values ('Jack', CURRENT)
Note: hour column should be defined as 'datetime' type of the
required precision
--
\\\\|//
Vijay R. Anisetti |6 6|
-------------------oooO--U--Oooo------------------------
oooO Oooo
( ) ( ) Just hangin in there
---------------\\( -- )/---------------------------------
\\) (/