|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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? |
|
#2
|
|||
|
|||
|
select to_date('31/MAR/2004', 'DD/MON/YYYY') from dual;
this is an example of converting your format to an Oracle date. ~jimbag8 |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Date format from asp form to oracle database? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|