Re: Query/400

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

> On Tue, 2021-11-16 at 11:48 -0500, Art Tostaine, Jr. wrote:
> I'm trying to modify an old *QRYDFN to convert an 6,0 field to a time.
>
> I've tried all sorts of combinations in the result field options but can't
> get anything to work.  If there is a way I can create a view that converts
> to time and use that instead that would be fine.
>
> I need to do this because the output file is converted to CSV using
> CPYTOIMPF. I need the editing in the CSV so Excel recognizes the column as
> a time.
>
> Thanks, Art
>
> [https://www.medtronsoftware.com/img/MedtronMinilogo.bmp]
> Kevin Bucknum
>
> Senior Programmer Analyst
>
> MEDDATA / MEDTRON
>
> 120 Innwood Drive
> Covington LA 70433
> Local: 985-893-2550<tel:985-893-2550>
> Toll Free: 877-893-2550<tel:877-893-2550>
> https://www.medtronsoftware.com
>
>
> CONFIDENTIALITY NOTICE
>
> This document and any accompanying this email transmission contain
> confidential information, belonging to the sender that is legally
> privileged.  This information is intended only for the use of the
> individual or entity named above.  The authorized recipient of this
> information is prohibited from disclosing this information to any other
> party and is required to destroy the information after its stated need has
> been fulfilled.  If you are not the intended recipient, or the employee of
> agent responsible to deliver it to the intended recipient, you are hereby
> notified that any disclosure, copying, distribution or action taken in
> reliance on the contents of these documents is STRICTLY PROHIBITED.  If you
> have received this email in error, please notify the sender immediately to
> arrange for return or destruction of these documents.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com