1
2
3
4
5
6
7
8
9
10
11
12
13
|
| select get_format(DATE,'EUR'), get_format(DATETIME,'EUR'), get_format(TIME,'EUR');
select get_format(DATE,'USA'), get_format(DATETIME,'USA'), get_format(TIME,'USA');
select get_format(DATE,'JIS'), get_format(DATETIME,'JIS'), get_format(TIME,'JIS');
select get_format(DATE,'ISO'), get_format(DATETIME,'ISO'), get_format(TIME,'ISO');
select get_format(DATE,'INTERNAL'), get_format(DATETIME,'INTERNAL'), get_format(TIME,'INTERNAL');
set @mode='EUR';
select get_format(DATE,@mode);
select get_format(DATE,'');
select get_format(DATE,null);
|
