How can i convert the date on the format(dd/mm/yyyy or dd/mm/yy) to oracle's date format dd/mmm/yy before inserting a record? is there any javascript/vbscript function available? pls guide me.

Thankx!


Yours,
Saran

__________________
Best Regards,
Saran.

You could use some kind of String mnipulation to reorder the string elements, or you could use the Date object to split out the components as well. Although why not just use the Oracle TO_DATE and TO_CHAR functions to convert your date as part of the SQL ?

thanks greg,
  now it's working. i use to_date like "To_Date(sysdate)"
thank u!
Yours,
Saran