Re: Datetime Problem between Powerbuilder and Informix

In article <6fpvud$u48$1@nnrp1.dejanews.com>, zzavadil@hotmail.com (Zdenek Zavadil) wrote: > > In article <6fp9ec$a7n$1@nnrp1.dejanews.com>, > Thenardier@POBoxes.com wrote: > > Hi, > > > > Seems powerbuilder's functions is unable to convert datetime > > fields for informix database properly. When i use the update() > > function to physically update the datetime field to informix in > > a datawindow. It displays a message like this: > > -1264 Extra characters at the end of a datetime or interval > > However, if i use a INSERT statement, it works fine. > > Can anyone tell me how to deal with the -1264 problem? Seems > > it's already been a bug in earlier versions of powerbuilder. > > But powersoft just leave it unsolved. > > thanx for u help. > > rgds, > > Thenard > > > > Thenard, > try to use the database column type DATETIME YEAR TO FRACTION(5). > > HTH, > Zdenek Tried, but failed. :( Did u use it successfully before? Can u show me ur way? Thanx!! Thenard -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading