Solved

Problem in Date field

Posted on 2003-11-20
6
268 Views
Last Modified: 2013-12-26
The question is littlebit tricky, in which i had developed a Web base application using ASP that run on IIS web server. The database is ORACLE on UNIX Platform. When i deploy the site on Windows NT running with IIS 5, it works fine. But the same i deploy on Windows 2000 server running IIS 5 the problem is coming.
In this, when i save the data through web browser, Particularly date field, it inserts the data by making mm(month) part to dd(datepart) and viseversa. This is the case for date and month less than 12. So what is the actaul problem and what is the solution?

Pl. help me.
0
Comment
Question by:shahsaurabhu
6 Comments
 
LVL 3

Expert Comment

by:savalou
ID: 9787344
So the only change was going from NT to Windows 2000?  You could try setting the regional date setting on the Win2K to a d/M/y format.  Or M/d/y, whichever.  What does your Oracle expect?  If you got a date out of it, how is it formatted?
0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 9799837
Oracle is very picky about date formats, it have to be defined for the view.
So it's most likely your ASP which did it wrong, 'cause haven't changed the SQL in ASP, did you?
savalou's suggestion seems to be the solution
0
 
LVL 3

Expert Comment

by:savalou
ID: 9800316
I also seem to remember a chartodate or some-such function for oracle where you can also specify the date format, sort of like the following:

insert into mytable (mydate) values (chartodate('4/3/03', 'd/M/y'))

There is also a date-to-char function.  I'd look in the oracle docs if that seems useful.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 51

Expert Comment

by:ahoffmann
ID: 9800490
if the same script works on NT but not w2k, it's most likely not SQL
0
 
LVL 18

Expert Comment

by:liddler
ID: 10191750
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ  No refund

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

liddler
EE Cleanup Volunteer
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 10241732
PAQed - no points refunded (of 250)

modulo
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
if loop in java 3 129
Smart Camera scanning and reading information 3 100
ShiftLeft challenge 21 76
withoutTen challenge 14 99
Introduction: Finishing the grid – keyboard support for arrow keys to manoeuvre, entering the numbers.  The PreTranslateMessage function is to be used to intercept and respond to keyboard events. Continuing from the fourth article about sudoku. …
Introduction: The undo support, implementing a stack. Continuing from the eigth article about sudoku.   We need a mechanism to keep track of the digits entered so as to implement an undo mechanism.  This should be a ‘Last In First Out’ collec…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now