RE: numeric conversion

Posted in 1999

Marichamy, Udaykumar — Mon, 23 Aug 1999 14:51:26 -0500 — source: Informix-list mailing list archive (1991-1998)

I am interested in a solution too. We have stored some dates as integer to store dates in the format yyyymm. The user prefered the integer type for easier manipulation from the front-end. For example, how to determine the year from the integer value 199907. Uday -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Monday, August 23, 1999 3:45 PM To: Michele.Orcutt@windmere.com; informix-list@iiug.org Subject: Re: numeric conversion From: Michele Orcutt <Michele.Orcutt@windmere.com> > >Hello. I have what I think is a simple question, only I'm having a lot of >trouble finding an answer. All my dates are saved as type numeric. I would >like >to convert some of the fields to "date". I cannot find the correct syntax >to >perform this conversion. Can it be done? Why are your dates stored as numerics? There is a datatype called DATE, and it's there to store dates. So that you don't have to do this sort of thing. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com