Table 161 CONVDATE Function Examples
Function |
Returns value |
---|---|
CONVDATE('30/05/00','DD/MM/YY','MM/DD/YY') |
05/30/00 |
CONVDATE('30/05/00','DD/MM/YY','YY/MM/DD') |
00/05/30 |
CONVDATE('30/05/00','DD/MM/YY','MM.DD.YY') |
05.30.00 |
CONVDATE('30/05/00','DD/MM/YY','YY-MM-DD') |
00-30-05 |
CONVDATE('30/05/00','MM/YY','YY-DD-MM') |
05-DD-30 |
CONVDATE('30/05/00','YY','YY-DD-MM') |
30-DD-MM |
CONVDATE('30/05/00',' ','YY-DD-MM') |
YY-DD-MM |
CONVDATE('30/05/00','DD/MM/YY',' ') |
[blank] |
CONVDATE('30/05/00','DD/MM/YY','MM-YY') |
05-00 |
Parent Topic |