Re: Informix 4gl pgm to reformat dates to Month dd, yyyy

Michael Segel wrote: > > KirbyRamz wrote: > > > I was not able to find any formatting that would format dates to > show the month > > spelled out so I wrote the following pgm. > > If there is any other programs that already do the same please > reply. > > > > Kirby Ramsey, Visual Services Inc., Bloomfield Hills, MI > > Uhmmm, well, this is kinda a funny question, but I'll ask it > anyways...... > > Why? > Ok, the dates are all stored in an internal datatype. The number of > days since Jan 1, 1900. That being 1. > > When you pull a date from the database, you can display it, using 4GL > to do exactly what you want. > Sorry I don't have the manual in front of me, but if you do a DISPLAY > USING, I think it would work. (Anyone have the exact syntax?) DISPLAY var USING "mmm dd, yyyy" > So what is it that you are trying to do, that I am missing? This only gives the first three characters of the month. I don't know of a format that gives the whole month name. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+