RE: date conversion

Hello all,

As requested, here's the SQL I ended up using. I always tend to forget about those system tables and they are dang useful....


select * from
table(qsys2.object_statistics('ELYRIA2', '*PGM *SRVPGM *FILE *USRSPC *DTAARA'))
where objname in
('OEB631L',
'OEB631L.',
'OEB6312L',
'OEB6313L ',
'OEB6313L.',
'OEB6314L ',
'OEB632L',
'OE631FM'
)
and (last_used_timestamp is null or date(last_used_timestamp) > '2021-12-01')
order by objname

Bill Howie[Related image]<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<https://www.hc-companies.com/>
Leader in Horticultural Containers
[cid:c1593a6b-b0a1-4492-8627-55ac14a1f6cd]<https://www.linkedin.com/company/the-hc-companies> [cid:2213e0e4-9c20-434e-9891-2f0846154e90] <https://www.facebook.com/HCCompanies/> [cid:39e7a9dc-7b6b-4eb3-82aa-30e93eae4fad] <https://www.instagram.com/hccompanies/> [cid:d3ef9032-e0ac-4630-90f9-8b112f138484] <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.