Timezones whoops in Iphone and Safari with Daylight Savings

Looping through October dates in 2015 for Sydney Australia, I was finding it weird that I had 32 days ! I'm fairly sure that wasn't how the rhyme went.

Anyway, looking into it, turned out that when starting at 1/10/2015 and adding 1 day til the end of the month, you ended up with 1,2,3,3,4 - see an extra day there which seems like Sat showed up twice.

Turns out, there appears to be a big in the "Spring Forward" part of the Javascript engin there where Midnight on 4/10/2015 is interpreted as actually being 3/10/2015 at 23:00, go figure.

In reverse, 5/4/2015 ("Fall Back") was displayed as 5/4/2015 at 1AM!!!!

See the quirks below which appears in Chrome; try on an iPhone to see for yourself.


Of course it was already asked over there on at stackoverflow.

DateTimeZone OffsetMonthDay Of MonthTimeUTC Hours
Sun Apr 05 2015 00:00:00 GMT+1100 (AUS Eastern Daylight Time)-66035142815240000013
Sun Apr 05 2015 01:00:00 GMT+1100 (AUS Eastern Daylight Time)-66035142815600000014
Sun Apr 05 2015 02:00:00 GMT+1100 (AUS Eastern Daylight Time)-66035142815960000015
Sun Apr 05 2015 03:00:00 GMT+1000 (AUS Eastern Standard Time)-60035142816680000017
Sun Apr 05 2015 04:00:00 GMT+1000 (AUS Eastern Standard Time)-60035142817040000018
Sun Oct 04 2015 00:00:00 GMT+1000 (AUS Eastern Standard Time)-60094144388080000014
Sun Oct 04 2015 01:00:00 GMT+1000 (AUS Eastern Standard Time)-60094144388440000015
Sun Oct 04 2015 03:00:00 GMT+1100 (AUS Eastern Daylight Time)-66094144388800000016
Sun Oct 04 2015 03:00:00 GMT+1100 (AUS Eastern Daylight Time)-66094144388800000016
Sun Oct 04 2015 04:00:00 GMT+1100 (AUS Eastern Daylight Time)-66094144389160000017





Script to produce this is:

<table border="1">
<tr><td>Date</td><td>TimeZone Offset</td><td>Month</td><td>Day Of Month</td><td>Time</td><td>UTC Hours</td></tr>
<script>
var d = new Date(2015,3,5, 0,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,3,5, 1,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,3,5, 2,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,3,5, 3,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,3,5, 4,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");

var d = new Date(2015,9,4, 0,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,9,4, 1,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,9,4, 2,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,9,4, 3,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2015,9,4, 4,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");


var d = new Date(2016,3,3, 0,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2016,3,3, 1,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2016,3,3, 2,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2016,3,3, 3,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");
var d = new Date(2016,3,3, 4,0,0);// Oct
document.write("<tr><td>" + d + "</td><td>" + d.getTimezoneOffset() + "</td><td>" + d.getMonth() + "</td><td>"+ d.getDate() + "</td><td>"+ d.getTime() + "</td><td>"+ d.getUTCHours() + "</td></tr>");

</script>
</table>

Comments

Post a Comment

Popular posts from this blog

Global SQL Procedure, System Objects and sp_ms_marksystemobject

You may come across a need to have a database of utils full of generic procedures which work on indvidual databases (say client databases). You can't pass the database name into the procedure as a parameter and say "use @dbname" in the procedure and dynamic sql sucks. One workaround is to create the procedure in the master database and then mark it as a system object. eg use [master] create procedure sp_doThis // note the sp_ prefix is required begin // etc etc end go exec sp_ms_marksystemobject 'sp_doThis' // second note, this procedure is undocumented, so I wouldn't be relying on this for life or death. use [myotherdb] exec sp_doThis go All done!
Read more

cf_sql_timestamp vs cf_sql_date vs getdate()

If there's one thing I don't like it is people confusing a date with a timestamp, and how a lazy bit of development can ruin a load of data. Here is a simple query inserting data to a timestamp I found in a system where all the created dates were truncated because of the incorrect syntax. Bad one which was in use: insert into testdate values (<cfqueryparam cfsqltype="cf_sql_date" value="#createodbcdatetime(now())#">); Result :  2015-09-29 00:00:00.000 Best One (easiest to read) insert into testdate values(getdate() ); Result : 2015-09-29 10:10:09.880 Not great (no binding) insert into testdate values(#createodbcdatetime(now())#); Result :  2015-09-29 10:14:44.000 What the bad one should have been insert into testdate values(<cfqueryparam cfsqltype=" cf_sql_timestamp " value="#createodbcdatetime(now())#">)
Read more

Lucee 4.5.2 cfpdfparam difference with Adobe ColdFusion

Suppose the following on Lucee 4.5.2: <cfset x = 1> <cfdocument format="pdf" pagetype="A4" name="myVar#x#"> <cfdocumentsection> Hi there </cfdocumentsection> </cfdocument> <cfpdf action="merge" destination="RAM:///myPDF.pdf" overwrite="yes">     <cfpdfparam source="#evaluate("myVar#x#")#" /> </cfpdf> <cfcontent file="RAM:///myPDF.pdf" type="application/pdf"> then to check it also runs on Adobe Cf; you'd actually end up with: "ByteArray objects cannot be converted to strings."   The original code for Adobe CF ran with the paramater like so:  <cfpdfparam source="myVar#x#" /> Both sets of documentation list source defined as follows: "Source PDF file to merge. You can specify a PDF variable, a cfdocument variable, or the pathname to a file." This would indicate it is just...
Read more