Re: Date conversion technique in QUERY

[Padman Kumar <padmancp@xxxxxxxxxxxxx>]

hi ,

        in CL programming there is a command CVTDAT.using this command u can
change date from any format to other format.try this.

At 06:43 AM 2/9/99 -0500, you 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
>
>
>Attachment Converted: c:\eudora\attach\Carl J. Galgano.vcf
>
_____________________________________________________________________
CH.PADMAN KUMAR(mailto:padmancp@wipsys.ge.com)
______________________________________________________________________ 
                                      

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---