penggunaan to char to date pada oracle

tanggal di oracle, to_char -> convert data tanggal ke char ,, sedangkan to_date -> convert data char ke date

q> Example to_char :

SELECT TO_CHAR(sysdate,'YYYY-MM-DD') to_char FROM DUAL;

q> Example to_date :

SELECT TO_DATE('2013-12-01','YYYY-MM-DD') to_date FROM DUAL;

q> Selsai

Published by

saifiahmada

Begin a big Process with a bit trying

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s