A Oracle SQL Tips

xiaoxiao2021-03-06  154

I used to know SELECT TO_DATE ('2001-02-16', 'YYYY-MM-DD') from DUAL

I can see it today to write SELECT DATE '2001-02-16' from Dual.

Return is a collection of Date types

Similar to SELECT TIMESTAMP '2004-01-31 11:20:11' from dual

转载请注明原文地址:https://www.9cbs.com/read-128394.html

New Post(0)