Date formats

Results 1 to 4 of 4

Thread: Date formats

  1. #1
    Wiiiiiill Guest

    Default Date formats

    Hello,<BR><BR>I&#039;ve got a date. Lets say it&#039;s stored in Dim date.<BR><BR>It&#039;s read from an SQL database over which I have no control.<BR>The date in the database is in English format : day/month/year.<BR><BR>When the date is written to my page by the script, it&#039;s in American format month/day/year.<BR><BR>How can I get the date to display in English format on my page and why the hell is it changing format anyway?<BR><BR>Thanks.

  2. #2
    Eddie Campbell Guest

    Default RE: Date formats

    Blame Bill Gates for being American and assuming we all use mm/dd/yy dates.<BR><BR>To fix it, put Session.LCID=2057 at the top of every page.<BR><BR>BUT beware, Sql will expect to see the date in mm/dd/yy format when you do selects etc. so you may need to switch the date back before using it in Sql

  3. #3
    Wiiiiiill Guest

    Default One more question...

    Where abouts at the top of the page?<BR><BR>&#060;%<BR><BR>Session.LCID=2057<BR>< BR>There???<BR><BR>Thanks. :o)

  4. #4
    Eddie Campbell Guest

    Default Yes, that would work

    You can put it pretty much anywhere, and I believe that you can change the LCID value more than once on a page.

Posting Permissions

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