ASP and Oracle 'date format' problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ASP and Oracle 'date format' problems

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Unhappy

    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?
    ========
    LARRY ELLISON

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    42

    Unhappy

    I do not understand when you say <>.
    ========
    LARRY ELLISON

  4. #4
    Join Date
    Nov 2000
    Posts
    42
    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]
    ========
    LARRY ELLISON

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

    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 :(
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yep...

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

    Once is way good enough

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width