i have a date in oracle with this format DD-MM-YYY
and i want to convert it to datetime with this other format DD-MM-YYY HH24:MI
how can i proceed?
I've tried this but nothing is working :
to_date(the_date,'DD-MM-YYY HH24:MI')
and also this:
to_date(to_char(date_debut_p),'DD-MM-YYY HH24:MI')