Re: Year 2000
Posted in 1996
Topics: Stored Procedures & SPL, Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design
I was told by Informix that using 4GL, you would have to use a 4 digit year. The 2 digit year using an environment variable was for ESQL/C only. aland@informix.com (Colonel Panic) wrote: >In article <4l0ptk$9qp@minerva.ibernet.es>, Manel F. <mir@svt.es> wrote: >>Hi all. >>I use the format "dd/mm/yy" for data type. >>What will it happen at 2000 ??? >Do you mean that you are using that format for *displaying* DATE datatypes >(via "format=" in forms or via DBDATE="dmy2/")? >If so, users will only see "00" in the fields, which by itself is fine... >BUT, entering a date value with "00" for year will be interpreted as >the year 1900. >In the near future, the "default century for dates entered with 2-digit years" >will be selectable via an environment variable. >-- >(c) 1996 Alan Denney aland@informix.com > Amount former Congressman Dan Rostenkowski of > Chicago was fined for his mail-fraud convictions: $100,000 > Amount he will continue to draw > from a Congressional pension even while in prison: $100,000 per year. +-------------------------------------------------------------------+ | Paul K. Watje 4GL/Fourgen Programmer | | AEC Data Systems UNIX system administator | | San Antonio, TX Database Administrator | | watjep@NetXpress.com Blah, Blah, Blah, Blah | +-------------------------------------------------------------------+