我想将以下字符串转换为日期:
2004-09-30 23:53:48,140000000
我试过了:
to_date('#','YYYY-MM-DD HH24:MI:SS,FF9')
ORA-01821: date format not recognized.
对于Oracle,FF9是不正确的吗?
甲骨文只在DATE字段中存储分数至秒。
原文链接:https://www.f2er.com/oracle/206035.html改用TIMESTAMP:
SELECT TO_TIMESTAMP('2004-09-30 23:53:48,140000000',FF9') FROM dual
,可能会将其投放到DATE,然后:
SELECT CAST(TO_TIMESTAMP('2004-09-30 23:53:48,FF9') AS DATE) FROM dual