devxlogo

Date Insertion Format

Date Insertion Format

Question:
I am using VB6 with ADO 2.1. I am trying to insert a date value into a column that is of the Date datatype. I am receiving a date conversion failure error. I have tried to format the date with no success. What format does Informix require when inserting a date?

Answer:
Try using “2000-05-11” as your date format.

devx-admin

Share the Post: