DB2 To/From datetime - string date conversions
Posted on 2007-04-06
Problem with DB2 DATETIME data retrieved and placed in a vb.net string variable, then attempting to convert back to datetime in an update query.
A Datetime column has data that in a DB2 table. When retrieved and placed in a string variable, it looks like this: 1/1/1994 12:00:00 AM.
What do I need to do in the update query to have it in correct datetime format?
Could you also show a good way convert both to and from database (both directions)