Results 1 to 2 of 2

Thread: Nls_date_format

  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Unanswered: Nls_date_format

    I am using the code below to set tyhe NLS_DATE_FORMAT
    Set AltSess = Server.CreateObject("ADODB.Connection")
    AltSess.open strConn
    AltSess.Execute "ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YY'"

    This change appears to be being overridden. I can alter the NLS_DATE_FORMAT in sql plus and it sticks but not from the vb in my web pages. Any ideas on how i can force the NLS_DATE_FORMAT to stay dd/mm/yy? Thx.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Hopefully these will help:

    How do I delimit/format dates for database entry?
    http://www.aspfaq.com/show.asp?id=2023

    Could I get a little help with dates?
    http://www.aspfaq.com/show.asp?id=2040
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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