Change oracle date format

[vanjamier]

Hi, i need help in changing date format.

I need to update an oracle database however, i must have the format
22 FEB 2004

Unfortunately i use a date picker(javascript) which returns 22/02/2004.
(this happens in client side)

How do i change the format to "22 feb 2004" in the server before inserting into the database ?

I already have
strdate1 = Request.Form("date1")

how do i change this date format ?

Need help in this badly.. thanks alot .

[buntine]

Use the FormatDateTime() function.

See here: http://www.devguru.com/Technologies/vbscript/quickref/formatdatetime.html

You could also grab each portion of the date and generate the date explicitely.

[vanjamier]

Thanks for the link
however it doesnt show the format 22 FEB 2005