Date format from asp form to oracle database?

[chelleybabyger]

my database, sqlplus oracle, has a column ccexpiry, whch is set to date. In my form in asp, there will always be an error whenever i pass in a date that is not in the DD MMM YYYY which is the standard for oracle. My qn is how can i pass in a date that is in DD/MM/YYYY format?

This should be a common question, but i cant seem to find a working code. Can someone give me the codes please?

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Aaron Bertrand [MVP]]

You shouldn't try and pass a date in that format. How is the software
supposed to know if 06/08/2004 is June 8th or August 6th?

My recommendation: use an ISO standard format, rather than an ambiguous one.
e.g. YYYYMMDD or YYYY-MM-DD.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Michelle" <ch************@hotmail.com> wrote in message
news:uQ**************@TK2MSFTNGP11.phx.gbl...

my database, sqlplus oracle, has a column ccexpiry, whch is set to date.
In my form in asp, there will always be an error whenever i pass in a date
that is not in the DD MMM YYYY which is the standard for oracle. My qn is
how can i pass in a date that is in DD/MM/YYYY format?

This should be a common question, but i cant seem to find a working code.
Can someone give me the codes please?

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

[dlbjr]

<SCRIPT language="vbscript" runat="server">
Function ConvertToOracleDate(dtmDate)
If IsDate(dtmDate) Then
Dim arData(2)
arData(0) = Right("00" & Day(dtmDate),2)
arData(1) = UCase(MonthName(Month(dtmDate),True))
arData(2) = Year(dtmDate)
ConvertToOracleDate = Join(arData," ")
End If
End Function
</SCRIPT>

-dlbjr

Discerning resolutions for the alms

[Mark Schupp]

Take note of the other posts about universal date formats, then look up
TO_DATE() in the Oracle SQL documentation. TO_DATE is used to convert
strings in various formats to Oracle dates.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Michelle" <ch************@hotmail.com> wrote in message
news:uQ**************@TK2MSFTNGP11.phx.gbl...

my database, sqlplus oracle, has a column ccexpiry, whch is set to date. In my form in asp, there will always be an error whenever i pass in a date
that is not in the DD MMM YYYY which is the standard for oracle. My qn is
how can i pass in a date that is in DD/MM/YYYY format?
This should be a common question, but i cant seem to find a working code. Can someone give me the codes please?
************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &

ASP.NET resources...