ASP and Oracle 'date format' problems

[l-ellison]

Hi!

I'm managing my Oracle 8.0.5 by using ASP.

I've got a problem with date format, because in Oracle
it's DD-MMM-YYYY (23-DEC-1999), but in ASP it's
DD-MM-YY (23-12-99). So I get problems like 'not valid
month' when trying to modify a date via ASP.

I encourage users to change it manually, but it's
very hard for them.

I tried (on Oracle) with:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YY'
but it does not work.

I tried (on ASP when loggin) with:
querydate = "ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YY'"
set rsdate = connection.execute (querydate)
but It does not work.

Any suggestion?

[sambavan]

Why not use the query with 'DD/MM/YY' in the formating method. By the way, you would want to look into changing the ASP date format, as that approach of DD/MM/YY is not advisible, as we all know the cause of Y2K problem.

So be aware of this type of formating.

Sam

[l-ellison]

I do not understand when you say <>.

[l-ellison]

I do not understand when you say: "use the query with 'DD/MM/YY' in the formating method"

When you pass the query to the database send it to get it formated as you want.

example:

select sysdate from dual;

Formated way is;

SQL> select sysdate from dual;

SYSDATE
---------
20-JUL-01

SQL> select to_char(sysdate,'DD/MM/YYYY') "My Date" from dual;

My Date
----------
20/07/2001

SQL> select to_char(sysdate,'DD/MM/YY') "Your Date" from dual;

Your Dat
--------
20/07/01


Hope this would explain you.

Sam

[Edited by sambavan on 07-20-2001 at 12:13 PM]

[sambavan]

Sorry about the previous post, I ended up choosing the edit, instead of quote option. My moderator privileges had not warned me of this, as a result had allowed me to post as ellison.

My deepest appologies to this forum members on this mistake.

Sam :(

[jmodic]

Originally posted by sambavan
My moderator privileges had not warned me of this, as a result had allowed me to post as ellison.

My deepest appologies to this forum members on this mistake.

Typical DBA mistake: grant too powerfull privileges to a user and see what you get.....

[sambavan]

Yep...

Too much of privileges, too much of resposiblilites ...

Once is way good enough

Sam