Re: USING Format for DATES

Lars Johansson wrote: > > Hi c.d.i > > Working om Y2K Problems I have encountered a problem > when using DISPLAY DATEVAR USING "yyyymm". > The "yyyymm" format has worked in older versions of Informix 4GL, > that will be version < 6.00. > Now, on both 6.05.UD1 (DataGeneral) and 7.20.UD1 (Sun Solaris), > I have the problem that it gives me a empty string but ONLY when linking > with > -shared option. The -static linkning works. > > I would assume that it must have been a Informix "feature" that the "yyyymm" > format has ever worked. I suppose that a DATE format always must include > both Y, M and D parts in the format (otherwise, it wouldn't be a DATE would > it?) > But Why does it work on -static linkning ?? > > Anyone likes to comment on this ?? > > Would there be any work around ?? > > Lars Johansson > SystemConsultant > Kuwait Petroleum (Danmark) A/S > lajo@Q8.dk Sounds like an undocumented "feature". If you really want to have date precision to one month, just use DATETIME YEAR TO MONTH. I hope you didn't enter dates using this format. All bets are off about what day of the month might be assumed and whether it changed between versions. A workaround (in 4GL, not tested) is to do this: DEFINE text_date CHAR(6) DEFINE mydate DATE LET text_date = mydate USING "yyyymmdd" DISPLAY text_date ... -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/