G
Guest
I need to append records to a DB2 database from Access via ODBC. However,
many, if not all, of the date fields that I need to populate are
timestamp-type fields. Although not inserted automatically by the server,
they appear as text in this format: yyyy-mm-dd-ss.ssssss.
Reading dates from DB2 into Access, I have to convert the string to a date.
The larger problem, however, is creating dates during the append process. I
had to write a function to break the date up into Year, Month, & Day, and
then use these to build a string to add the seconds & sub-seconds. Is there a
setting in the ODBC driver that will allow me to see the DB2 dates in one of
the available Access date formats or at least convert them when I append?
many, if not all, of the date fields that I need to populate are
timestamp-type fields. Although not inserted automatically by the server,
they appear as text in this format: yyyy-mm-dd-ss.ssssss.
Reading dates from DB2 into Access, I have to convert the string to a date.
The larger problem, however, is creating dates during the append process. I
had to write a function to break the date up into Year, Month, & Day, and
then use these to build a string to add the seconds & sub-seconds. Is there a
setting in the ODBC driver that will allow me to see the DB2 dates in one of
the available Access date formats or at least convert them when I append?