tanggal di oracle, to_char -> convert data tanggal ke char ,, sedangkan to_date -> convert data char ke date
q> Example to_char :
[sourcecode language="sql"]SELECT TO_CHAR(sysdate,'YYYY-MM-DD') to_char FROM DUAL;[/sourcecode]
q> Example to_date :
[sourcecode language="sql"]SELECT TO_DATE('2013-12-01','YYYY-MM-DD') to_date FROM DUAL;[/sourcecode]
q> Selsai
No comments:
Post a Comment