Re: Retrieving Dates from Informix Into Powerbuilder

Posted in 1996

Bahram Samani — Thu, 25 Jul 1996 09:31:49 -0400 — source: Informix-list mailing list archive (1991-1998)

STEVE_LOYD@HP-SanJose-om1.om.hp.com wrote: > > Item Subject: cc:Mail Text > > > > Hello... Any Informix / Powerbuilder developers, > > With my .profile informix DBDate=MDY4/ matching my NT International > short date format on the client, I have the following symptoms: > > 1. Dates can be entered and retrieved correctly with DBACCESS. > > 2. Dates can be inserted via PowerBuilder DataWindow (or using > embedded sql) into the database and then can be viewed correctly > using DBACCESS. > > 3. When retrieving date values into Powerbuilder DataWindow, date > formats return ??/??/0000 In addition to not being able > to view the date (which is correct in DB using DBACCESS), updates > from within Powerbuilder cannot be performed erroring with "bad > date format" 1. look at the INET setup on your PC. The date format in INET could be wrong. 2. There is a bug in PB5 with datetime it does not format the datetime correctly when you do an update or insert. > > > please help, > > Steve Loyd