Hi,
I just learnt this SQL language and I'm a student. Could you please tell me how do you insert time into the table? I know you can use TO_DATE('dd/mm/yyyy' , 'xx/xx/xxxx') to insert dates into the table, but how do you insert time e.g. 10.00AM??? I already tried using TO_DATE('HH:MI AM', 'xx:xx AM/PM') but it doesn't work!!!
Thanks in advance...!
I just learnt this SQL language and I'm a student. Could you please tell me how do you insert time into the table? I know you can use TO_DATE('dd/mm/yyyy' , 'xx/xx/xxxx') to insert dates into the table, but how do you insert time e.g. 10.00AM??? I already tried using TO_DATE('HH:MI AM', 'xx:xx AM/PM') but it doesn't work!!!
Thanks in advance...!