Link to home
Start Free TrialLog in
Avatar of sujatha060198
sujatha060198Flag for United States of America

asked on

VB 4.0 & Informix 6.0 DateTime Query

I have a Informix 6.0 and VB 4.0 and used  ODBC. I can use sql query for returning recordset of text, integer and other data field.
My problems is how to query DateTime data fields. My date fields is in yyyy/mm/dd hh:nn:ss formats in Informix.

ASKER CERTIFIED SOLUTION
Avatar of yowkee
yowkee

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sujatha060198

ASKER

Informix datetime format also are in the format of '1998-06-08 14:46:22'. So one must make sure in which format they are before making the date time.