Re: Date conversion technique in QUERY

[Howard Weatherly <hweatherly@xxxxxxxxxxxx>]

Carl,

One way would be to
SELECT SUBSTR(DATE,3,4) || SUBSTR(DATE,1,2) FROM FILE INTO :FIELD

Carl Galgano wrote:

> anyone have a quick and dirty way to convert a date (6,0) in a YYMMDD format
> to a MMDDYY format for printing in a Query?  I know I can multiply by
> 100.0001, however Query thinks it knows better and won't let you chop off
> the left most 2 significant digits, which makes this technique not work.  (I
> get the dreaded +++++++++ as the output for this field).
> Surely someone has solved this little problem.
> TIA,
> Carl
> Carl Galgano
> EDI Consulting Services, Inc.
> 540 Powder Springs Street
> Suite C19
> Marietta, GA  30064
> 770-422-2995
> mailto: cgalgano@ediconsulting.com
> http://www.ediconsulting.com
> EDI, Communications and AS400 Technical Consulting

--
Howard
__________________________________________________________________

begin:vcard 
n:Weatherly;Howard
tel;pager:(800)691-7499
tel;cell:(616)260-6796
tel;fax:(616)961-7091
tel;home:(616)979-8739
tel;work:(616)961-4324
x-mozilla-html:TRUE
org:Computer Task Group / Battle Creek Federal Ctr.
adr:;;74 N. Washington;Battle Creek ;Michigan;49017;US
version:2.1
email;internet:hweatherly@dlis.dla.mil
title:Sr. Software Engineer.
x-mozilla-cpt:;2272
fn:Howard Weatherly
end:vcard