Re: Date conversion

[Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>]

this is beyond the scope of the questioner, what can we do with the
ODDCEN (century value), so we have a properly interpreted 8 position date?

On Wed, May 3, 2023 at 4:31 PM Michael Mayer <michael.mayer@xxxxxxxxxxxxx>
wrote:

> I suggested this but it didn't work as far as I can tell. Sorry.
>
> This might help .. you'll have to test it out.
> Open ACS Run SQL Scripts
>   Click "edit" in the toolbar
>     Open JDBC Configuration
>       Click 'edit"
>         Click format and change date format as you like.
>
> Respectfully,
> Michael Mayer
> IBM i on Power System Admin
> ERMCO-ECI
> 2225 Industrial Rd
> Dyersburg, Tennessee 38024
> Office and OnCall: 731.676.4318
> Cell: 518.641.8906
> Email: michael.mayer@xxxxxxxxxxxxx<mailto:michael.mayer@xxxxxxxxxxxxx>
> https://www.ermco-eci.com<https://www.ermco-eci.com/>
> IBM i Personal Blog: https://ibmireference.blogspot.com<
> https://ibmireference.blogspot.com/>
> "Success is not final. Failure is not fatal. It is the courage to continue
> that counts".
>
>
> [cid:image001.gif@01D97DDC.9ADA5FA0]
>
>
>
>
>
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:
> midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Howie, Bill
> Sent: Wednesday, May 3, 2023 4:00 PM
> To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Date conversion
>
> Hello all,
>
> I have what is surely a simple question but I can't seem to find an answer
> to it. I have a work file that I've created that contains the output of the
> DSPOBJD command for a particular library. This file has the field ODUDAT,
> which is the date last used field. It's a character field in the MMDDYY
> format. I'm using Run SQL Scripts in ACS to then query this file, but I'd
> like to convert this date to YYYYMMDD format so that I can order the query
> results by the most recent date. The only way I can find that comes close
> to working so far is just to substring the ODUDAT field into the month,
> day, and year portions and then play with it that way. I'm sure there's a
> more elegant method that will just yield a YYYYMMDD field. Thoughts?
>
> Any ideas on this would be greatly appreciated. Thanks!
>
> Bill Howie[Related image]<https://www.hc-companies.com/<
> https://www.hc-companies.com>>
> Senior ERP Programmer/Analyst
> Office: 330.486.5818 | Cell: 330.486.5818 | Toll Free: 800.225.7712
> 2450 Edison Blvd., Suite 3, Twinsburg, OH 44087
> hc-companies.com<http://hc-companies.com><https://www.hc-companies.com/<
> https://www.hc-companies.com/>>
> Leader in Horticultural Containers
> [cid:e0b218dc-8ff8-41fd-81d2-b4ddf650420b]<
> https://www.linkedin.com/company/the-hc-companies<
> https://www.linkedin.com/company/the-hc-companies>>
> [cid:5a6b8cad-48ce-4933-8f87-19d7d96844ba] <
> https://www.facebook.com/HCCompanies/<https://www.facebook.com/HCCompanies>>
> [cid:151d0fd6-bc45-4922-8e5f-cf1f42b0de8f] <
> https://www.instagram.com/hccompanies/<
> https://www.instagram.com/hccompanies>>
> [cid:19fc1ef7-7bff-4cae-87af-ec061a1c8770] <
> https://twitter.com/hc_companies<https://twitter.com/hc_companies>>
>
> Disclaimer
>
> The information contained in this communication from the sender is
> confidential. It is intended solely for use by the recipient and others
> authorized to receive it. If you are not the recipient, you are hereby
> notified that any disclosure, copying, distribution or taking action in
> relation of the contents of this information is strictly prohibited and may
> be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
> automatically archived by Mimecast Ltd, an innovator in Software as a
> Service (SaaS) for business. Providing a safer and more useful place for
> your human generated data. Specializing in; Security, archiving and
> compliance. To find out more visit the Mimecast website.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
> MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l<
> https://lists.midrange.com/mailman/listinfo/midrange-l>
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
> MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l<
> https://archive.midrange.com/midrange-l>.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
> support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
>
>
> The information in this email may be confidential. It is intended only for
> the person(s) named above. If you are not the intended recipient, please
> notify the sender and do not review, distribute, or duplicate this email.
> --
> 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.