query with date as ccyymmdd
"Ed and Mary" <[email protected]>
| Newsgroups | gmane.comp.lang.as400.mi |
|---|---|
| Message-ID | <005201c57223$a0e262e0$2702a8c0@amd2000> |
> Does anyone know how to represent this number, 20050615 as a date in a query (with separators)? MM/DD/CCYY. I tried a substr function to seperate and then combine the parts with a '/', but goit really weird results with each part. Of course I could not get the parts to combine. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.3/15 - Release Date: 6/14/2005 _______________________________________________ This is the MI Programming on the AS400 / iSeries (MI400) mailing list To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mi400 or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mi400.