Problem with LSParseDateTime function on server

Posted by Saul on Stack Overflow See other posts from Stack Overflow or by Saul
Published on 2011-01-16T12:20:35Z Indexed on 2011/01/16 12:53 UTC
Read the original article Hit count: 244

Filed under:
|
|

When I run this test code on my development machine it works as expected. CF9.01

I am in europe using euro date format so 10/09/1957 is 10th Sept 1957.

<cfset testDate="10/09/1957">
<cfoutput>
Initial string = "#testDate#"<br>
LSparsedatetime output = #lsparsedatetime(session.form.patientDOB)#<br>
parsedatetime output = #parsedatetime(session.form.patientDOB)#
</cfoutput>

Output on test machine is

Initial string = "10/09/1957"
LSparsedatetime output = {ts '1957-09-10 00:00:00'}
parsedatetime output = {ts '1957-10-09 00:00:00'}

Same code , output on live server is

Initial string = "10/09/1957"
LSparsedatetime output = {ts '1957-10-09 00:00:00'} 
parsedatetime output = {ts '1957-10-09 00:00:00'}

Server OS is Windows Web Server 2008 R2. I checked Control panel > date and time setting and it is correctly set to London. Web server is IIS7 but I don't think that would affect anything?

IN region and Language, location is set to United Kingdom and in Administrative (change system locale ) it is also correct as English (United Kingdom)

© Stack Overflow or respective owner

Related posts about datetime

Related posts about coldfusion