| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Mar | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||
- CSS (2)
- Javascript (3)
- LANSA (21)
- SQL (8)
- Twitter API (1)
- Uncategorized (25)
- 8. March 2010: American Express is Suing Me
- 28. January 2010: So frackin hard
- 1. September 2009: Twitter API STREAM Filter
- 15. June 2009: DOS Commands that work on Windows XP
- 14. April 2009: TWEATER CHEATER IS BORN
- 14. April 2009: Windows Keyboard Short Cuts - ALT F4 is my Favorite
- 11. April 2009: SELECT_SQL Examples
- 30. January 2009: My Recovery ID Idea
- 29. January 2009: Test Program to See what LANSA Services are Licensed
- 11. January 2009: glossary
LANSA Date Formats
Date Formats
Date Built-In Functions may use one or more of the following formats as arguments and/or return values. The relevant Built-In Function’s description tells you which format is used as arguments and/or return values.
|
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 |
|
1 |
CYYMMDD |
Leave a Reply
You must be logged in to post a comment.