| Code | Format of Date |
|---|---|
| A | System date format |
| B | DDMMYY |
| C | DD/MM/YY |
| D | YYMMDD |
| E | YY/MM/DD |
| F | MMDDYY |
| G | MM/DD/YY |
| H | DDMMYYYY |
| I | DD/MM/YYYY |
| J | YYYYMMDD |
| K | YYYY/MM/DD |
| L | MMDDYYYY |
| M | MM/DD/YYYY |
| N | DDMMMYY (e.g. 03JUL87) |
| O | DDMMMYYYY (e.g. 03JUL1987) |
| P | DDxx MMMMMMMMM YY (e.g. 16TH SEPTEMBER 87) |
| Q | DDxx MMMMMMMMM YYYY (e.g. 16TH SEPTEMBER 1987) |
| R | DDD (e.g. MON, TUE, WED, etc). |
| S | DDDDDDDDD (e.g. MONDAY, TUESDAY, WEDNESDAY, etc). |
| T | DDDDDDDDDD (in selected language e.g. LLLLLLLLLL). |
| U | MMMMMMMMMM (in selected language e.g. LLLLLLLLLL). |
| V | 8 digit system date format |
| W | YYMM |
| X | MMYY |
| Y | YYYYMM |
| Z | MMYYYY |
All one can think and do in a short time is to think what one already knows and to do as one has always done!
LANSA Date Formats Cheat Sheet
These are useful when doing LANSA date conversions using the DATE Built-in functions !
No comments:
Post a Comment
NO JUNK, Please try to keep this clean and related to the topic at hand.
Comments are for users to ask questions, collaborate or improve on existing.