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 .

[aspdaddy]

One way:
strDate2 = Day(strDate1) & " " & left(MonthName(month(strDate1)),3) & " " & Year(strDate1)

[mattglet]

If I remember my oracle days correctly, you can specify a date "mask" when you enter it into the database.

Don't quote me on that though... Maybe that was being done with the cold fusion I was using at the time.