RE: PB with DBDATE (IUS2000)

> > Hi All, > I'm running IUS 2000 on Sun ultra entreprise 450, I've set > the variable > DBDATE on my environement with Y4MD/. In my table the data are stored > under the format MM/DD/YYYY. And I get an error -1204: invalid year in > date while I try to update or insert. It seems pretty obvious, but why > the engine does not take care of my DBDATE setting ??? > We're running also webdriver (webblade web.3.36.uc6). I don't fully understand! Are you saying that the data in the table is not stored as a date but instead as a char. DBDATE converts informix dates ( which are stored as integer - I think ) into the required format. What is the data type of the date > > Any clues ???? > Thx for help. > > Steph. > > -- > _________________________________________________________________ > > Stephane Monier > DBA - System Engineer > REEF France > 116, rue du Faubourg Saint Martin - 75010 Paris > Phone 33 (0)1 55 26 53 59 - Fax 33 (0)1 55 26 53 55 > http://www.reef.com - http://product.reef.com > _________________________________________________________________ > > REEF is a global provider of Internetware for online publishing, > e-commerce, Web site administration and dynamic asset management. > _________________________________________________________________ > > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________