10.7.0-dbg>SELECT CURRENT_DATE();
|
+----------------+
|
| CURRENT_DATE() |
|
+----------------+
|
| 2021-09-20 |
|
+----------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>SELECT SFORMAT ('{:Y-m-d}',CURRENT_DATE());
|
+-------------------------------------+
|
| SFORMAT ('{:Y-m-d}',CURRENT_DATE()) |
|
+-------------------------------------+
|
| NULL |
|
+-------------------------------------+
|
1 row in set, 1 warning (0.001 sec)
|
|
10.7.0-dbg>SHOW WARNINGS;
|
+---------+------+---------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------+
|
| Warning | 4183 | SFORMAT error: invalid type specifier |
|
+---------+------+---------------------------------------+
|
1 row in set (0.000 sec)
|
|
10.7.0-dbg>SELECT SFORMAT ('{:Y-m-d}','2021-09-20');
|
+-----------------------------------+
|
| SFORMAT ('{:Y-m-d}','2021-09-20') |
|
+-----------------------------------+
|
| NULL |
|
+-----------------------------------+
|
1 row in set, 1 warning (0.000 sec)
|
|
10.7.0-dbg>SHOW WARNINGS;
|
+---------+------+---------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------+
|
| Warning | 4183 | SFORMAT error: invalid type specifier |
|
+---------+------+---------------------------------------+
|
1 row in set (0.000 sec)
|