Classic ASP Discussion - Session.LCID problem

Print Page | Close Window

Session.LCID problem

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=12169
Printed Date: 31 March 2026 at 1:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Session.LCID problem

Posted By: Pegaso
Subject: Session.LCID problem
Date Posted: 14 October 2004 at 9:13am

Hi,

i'm back whit a new great problem .

I insert in a Form the date ex. 09/01/2004 (9 Jan 2004) and i store it to the database. When i call it back the value is 01/09/2004 (1 sept 2004).

The great problem is that in the database i have stored over 1'500 dates in dd/mm/yyyy format and i can see it correctly thanks the session.LCID command.

How can i save the dates correctly (dd/mm/yyyy) in the database stored on a Server that has the format mm/dd/yyyy.

Thank's to all for the answer.

-------------

Replies:

Posted By: zaboss
Date Posted: 14 October 2004 at 9:24am

It's not how you store them that matters, but how you process them...
Working with different databases, mySQL, Access, SQL Server, I have developped a way of inserting them by a specific format and retrieving them by a specific format. I don't care how it is stored in the db, as long as I am triggering the right figures for months and days using the DatePart function.
Inserting them in the right formula is crucial as, especialy Access tends to mistake days for months in day's numbers that are less than 12 (for instance 3 of may might be mistaken for 5 of march or your example)...

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web