B4J Question [SOLVED embarrassingly] Daylight saving has some unexpected effects

[JackKirk]

I just started this thread in the bugs section:

What happened on 29 October 1984?

Hi, This has me mystified, if you run this bit of code: Private Sub AppStart(Form1 As Form, Args() As String) DateTime.DateFormat="yyyy-MM-dd" Private wrk_datelong1, wrk_datelong2 As Long wrk_datelong2 = DateTime.DateParse("1984-10-25") wrk_datelong1 =...

www.b4x.com

But Erel has decided it is a question, not a bug.

I have another example:

Private Sub AppStart(Form1 As Form, Args() As String)

    DateTime.DateFormat="yyyy-MM-dd"

    Private wrk_datelong1, wrk_datelong2 As Long

    wrk_datelong2 = DateTime.DateParse("1985-02-27")

    wrk_datelong1 = DateTime.DateParse("1985-02-28")
    Log("1985-02-28 " & wrk_datelong1 & " " & (wrk_datelong1 - wrk_datelong2))
    wrk_datelong2 = wrk_datelong1

    wrk_datelong1 = DateTime.DateParse("1985-03-01")
    Log("1985-03-01 " & wrk_datelong1 & " " & (wrk_datelong1 - wrk_datelong2))
    wrk_datelong2 = wrk_datelong1

    wrk_datelong1 = DateTime.DateParse("1985-03-02")
    Log("1985-03-02 " & wrk_datelong1 & " " & (wrk_datelong1 - wrk_datelong2))
    wrk_datelong2 = wrk_datelong1

    wrk_datelong1 = DateTime.DateParse("1985-03-03")
    Log("1985-03-03 " & wrk_datelong1 & " " & (wrk_datelong1 - wrk_datelong2))
    wrk_datelong2 = wrk_datelong1

    wrk_datelong1 = DateTime.DateParse("1985-03-04")
    Log("1985-03-04 " & wrk_datelong1 & " " & (wrk_datelong1 - wrk_datelong2) & " <<<<<<<<<")
    wrk_datelong2 = wrk_datelong1

    wrk_datelong1 = DateTime.DateParse("1985-03-05")
    Log("1985-03-05 " & wrk_datelong1 & " " & (wrk_datelong1 - wrk_datelong2))
    
    'StartMessageLoop
    
End Sub

which when you run it gives this log:

Waiting for debugger to connect...
Program started.
1985-02-28 478357200000 86400000
1985-03-01 478443600000 86400000
1985-03-02 478530000000 86400000
1985-03-03 478616400000 86400000
1985-03-04 478706400000 90000000 <<<<<<<<<
1985-03-05 478792800000 86400000

if this an error on my part I would like to know what I am doing wrong.

 

[alwaysbusy]

Again, you shouldn't put it as a bug, but as a question. The chances there is a bug in B4X are phenomenally low...

I would look into the java SDK version you have installed, as on my PC (OpenJDK 11.0.1), I get the correct results:

Waiting for debugger to connect...
Program started.
1985-02-28 478393200000 86400000
1985-03-01 478479600000 86400000
1985-03-02 478566000000 86400000
1985-03-03 478652400000 86400000
1985-03-04 478738800000 86400000 <<<<<<<<<
1985-03-05 478825200000 86400000
Program terminated (StartMessageLoop was not called).

Also, you shouldn't make calculations like that to find a period between dates, as it doesn't work this way. You should use the jDateUtils library for that:

Log(DateUtils.PeriodBetween(wrk_datelong2, wrk_datelong1).Days)

 

[klaus]

I'm afraid that you will have this every year in October and March.
It's simply daylight saving time change.

 

[alwaysbusy]

simply daylight saving time change

That was my first thought too, but isn't the change at the end of march, not in the beginning?

 

[klaus]

I tested it for this spring and there is the difference.

2020-03-27 1585263600000 -86400000
2020-03-28 1585350000000 -86400000
2020-03-29 1585436400000 -82800000
2020-03-30 1585519200000 -86400000

I think that the date of change is not the same around the world.

 

[JordiCP]

Seems that the exact date was different some years ago (was also curious about it)

https://www.timeanddate.com/time/change/australia/sydney?year=1985

 

[Erel]

Thread title is bad. The thread title should summarize the question.

 

[Erel]

But Erel has decided it is a question, not a bug.

Not exactly true. However unless you are pretty sure that there is a bug then you should start in the questions forum.

As explained above it is not a bug. There are days with 23 hours and there are days with 25 hours.

 

[JackKirk]

Thread title is bad.

I modified it for posterity.

Bang head - daylight saving - of course.

Thanks all...