Re: Datetime Problem between Powerbuilder and Informix

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 > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading > Thenard, try to use the database column type DATETIME YEAR TO FRACTION(5). HTH, Zdenek -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading