去掉Oracle日期中前面的数字0
去掉Oracle日期中前面的数字0
- SQL> select to_char(hire_date,<span style="color:#ff0000;">'yyyy-MM-dd'</span>) from employees where rownum < 10;
- TO_CHAR(HI
- ----------
- 1999-06-21
- 2000-01-13
- 1987-09-17
- 1996-02-17
- 1997-08-17
- 1994-06-07
- 1994-06-07
- 1994-06-07
- 1994-06-07
- <span style="font-family:Arial;BACKGROUND-COLOR: #ffffff"></span>
- <span style="font-family:Arial;BACKGROUND-COLOR: #ffffff">可以看到前面是1994年06月07日,如何将06月中的0和07日中的0去掉?使用如下方法:</span>
- <span style="font-family:Arial;BACKGROUND-COLOR: #ffffff"></span>
- <span style="font-family:Arial;BACKGROUND-COLOR: #ffffff"></span><pre class="sql" name="code">SQL> select to_char(hire_date,<span style="color:#ff0000;">'fmyyyy-MM-dd'</span>) from employees where rownum < 10;
- TO_CHAR(HI
- ----------
- 1999-6-21
- 2000-1-13
- 1987-9-17
- 1996-2-17
- 1997-8-17
- 1994-6-7
- 1994-6-7
- 1994-6-7
- 1994-6-7
评论暂时关闭