Hello, everyone

I am developing an ASP application connecting to Oracle 9i, to search a date field, the date stalled in Oracle as '02-May-1999', where users search would like to enter to search box as 02/05/1999, is there any function could convert to 02/05/1999.

Thank you in advance

Peter

You can use the TO_DATE and TO_CHAR functions in Oracle, do a Google adn you'll find lots on the subject.

Thank you for you reply.
I have tried To_Date; To_Char; alter session set NLS_DATE_FORMAT = 'dd/mm/yyyy' ;
All above functions work fine in Oracle, but once I run query in ASP, it keep tell me, not a valid month.

The follow statement, it gives 'missing expression'

Select Format$(CDate(Left([Dispatch_Date],10)),'dd/mm/yyyy') AS DispatchDate.


I wonder if there is any function(VBscript or javascript) in search box or query in ASP, to convert to 'dd/mm/yyyy' from Oracle's format 'dd-mmm-yyyy' .

Pete

can you post some more of your code as it looks like you may have an issue with the SQL statement you pass to Oracle ? Have oyu tried capturing the SQL Statement in a string and printing it then seeing if it will run in SQL Plus ?