Date Inversion

		Wrox Programmer Forums > SQL Server > SQL Server ASP
Date Inversion

SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 16th, 2004, 02:49 PM

evandro.paula evandro.paula is offline

Authorized User

Join Date: Oct 2003

Posts: 17

Thanks: 0

Thanked 0 Times in 0 Posts

Date Inversion

I'm having a problem with a SQL Server 2000 and a ASP application, details:

When SQL saves the record that comes from a ASP (version 3) page, the birth date is in DD/MM/YYYY format is changed to the format YYYY/DD/MM while should be YYYY/MM/DD. It's changing de day and the month of the date.
I don't if could be the version of MDAC, SQL Server or even Windows.
I've tried to use Session.LCID=1046 in Global.asa an other .ASP files, but it did not work.
If anybody can help me please do it.

Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show Images from Start Date thru Date	istcomnet	Classic ASP Basics	2	May 23rd, 2008 07:12 AM
copy date values between date controls	Alcapone	Javascript How-To	1	April 13th, 2006 03:13 AM
How to give Date format while entering date	Subuana	Beginning VB 6	4	March 17th, 2006 07:25 AM
DTS Import ( Date string to Date field)	gfowajuh	SQL Server 2000	1	September 30th, 2003 06:28 AM
Convert String Date to Date for a SQL Query	tdaustin	Classic ASP Basics	4	July 7th, 2003 06:01 PM