ÇëÎÊÒ»¸öoracle to_dateµÄÎÊÌâ¡£

ÏÖÔÚÎÒ½«2009-10-20 09:22:52.0ÕâÑùµÄ×Ö·û´®£¬×ª»¯³ÉdateÀàÐÍ£¬²åÈëµ½±íÀï

ÎÒÓÃÁËÒ»ÏÂto_dateÊÔÑ飬
select to_date('2009-10-20 09:22:52.0', 'yyyy-MM-dd hh24:mi:ss') from dual

½á¹û±¨´í£¬ÔÚpl sql Àï¡£

ÇëÎÊÓ¦¸ÃÔõôת»»£¿

oracleµÄÈÕÆÚÀàÐÍÈ¡»ØÀ´¶¼ÊÇ.0µÄ

---

select to_date('2009-10-20 09:22:52', 'yyyy-MM-dd hh24:mi:ss') from dual

---

лл£¬ÎÒµÄ×Ö·û´®¾ÍÊÇ'2009-10-20 09:22:52.0'

×¢Òâ×îºóÓиö.0

---

select to_date(SUBSTR('2009-10-20 09:22:52.0',1,LENGTH('2009-10-20 09:22:52.0')-2), 'yyyy-MM-dd hh24:mi:ss') from dual

---

'YYYY-MM-DD HH24:MI:SS.ff'

ÊÔÊÔÕâ¸ö

---

ÒýÓÃ

select to_date(SUBSTR('2009-10-20 09:22:52.0',1,LENGTH('2009-10-20 09:22:52.0')-2), 'yyyy-MM-dd hh24:mi:ss') from dual

Õâ¸öÓ¦¸Ã¿ÉÒÔ

---

Èç¹ûÊÇÔÚPLSQLÖÐ,¿ÉÒÔÕâÑù×ö
declare
v_date date;
BEGIN
select to_timestamp('2009-10-20 09:22:52.0','yyyy-mm-dd hh24:mi:ss.ff1') into v_date from dual;
DBMS_output.put_line('v_date: ' ||v_date);
END;
/

---

SQL code:
select to_date('2009-10-20 09:22:52.0','YYYY-MM-DD HH24:MI:SS.ff') from dual;

Õâ¸ö·½·¨Ðв»Í¨Ñ½£¡
{{-