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: 280
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