Hi All


I have a varchar2 variable where i get the date which i need
to store in date column of a table


the varchar2 value is coming like this

dt_val := 'Wed Feb 18 07:00:00 IST 2004',


now i need to convert this into this date format
'dd/mon/yyyy hh:mi:ss am' and insert into a table

How to acheive this



Rgrds