Datediff problem between windows and Linux machine ?

[fgilain]

Hello,

I need to create a script using autoit on a windows computer to execute it on a remote linux server using putty (or plink) and this script needs to generate a string corresponding to the actuel date/time in the linux format (equivalent to the linux command : `/bin/date +%s`).

My problem is that it seems to generate it with 1 hour more than it should be..

maybe did i missed something ? here is the code i used :

$UnixDateSince1970 = _DateDiff( 's',"1970/01/01 00:00:00",_NowCalc())

Any idea of what i coul have missed ?

Nb : actually, it's 2013/02/22 01:20PM in France, and the result string is : 1361539258

thanks

Florent

[fgilain]

on the linux server, result is :

[root@remote_linux_server]# date

ven fév 22 13:22:20 CET 2013

[root@remote_linux_server]# date

ven fév 22 13:22:20 CET 2013

[root@remote_linux_server]# date

ven fév 22 13:22:20 CET 2013

[root@remote_linux_server]# /bin/date +%s

1361535757

seems to have 1 hour of difference too in the result ???? should i change something about the "CET" timezone somewhere on the linux ?

Edited February 22, 2013 by fgilain

[water]

What do you get if you run "date" on the linux machine? Is it GMT time?

[jchd]

1 hour might be difference from UTC to local time or daylight savings.

Sorting out which is which is up to you since we have no idea of both machines' settings.

[water]

Seems you can specify the timezone in the datestr:

"Sets the time and date to the value specfied in the datestr. The datestr may contain the month names, timezones, 'am', 'pm', etc. See examples for an example of how the date and time can be set."

[water]

Here is a complete list of format control characters supported by date command.

Add the timezone and see if the result changes.

Edited February 22, 2013 by water

[fgilain]

[root@remote_linux_server]# date

ven fév 22 18:14:18 CET 2013

[root@remote_linux_server]# date -u

ven fév 22 17:20:55 UTC 2013

Edited February 22, 2013 by fgilain

[fgilain]

Solution would be to get the "now date" from autoit in UTC format, no ?

Because actually it seems to return the GMT+1 datetime....

And what will happen at next change of hour here in france ?

Edited February 22, 2013 by fgilain

[Melba23]

fgilain,

Most users would want the local time - so that is what Autoit gives you. But you can use _Date_Time_GetTimeZoneInformation and convert to UTC yourself - look at the Help file to see how.

M23

[fgilain]

Sorry, i'm not a "professional developer"...i'm quite lost in all theses expert solutions...

As i need to generate from my windows computer a string representing the actual time (since 1970) that would be the same as if i had calculated it on my linux box (even if there were daylight saving changes), what would be the best way then ?

NB :today, i just did a "- 3600" to my result to remove 1 hour in the result of my windows computer (but i suppose it won't work anymore after the next daylight change here in france ?)

Edited February 22, 2013 by fgilain

[Melba23]

fgilain,

This should do the trick:

#include <Date.au3>

; Get local time
$sLocal_Time = _NowTime()
ConsoleWrite($sLocal_Time & @CRLF)
; Get time zone info - look in Help file to see what is in the different elements
$aTime_Info = _Date_Time_GetTimeZoneInformation()
; Convert local to UTC - you need to add the date to get the correct format
$sUTC_DTG = _DateAdd("n", $aTime_Info[1], _NowCalcDate() & " " & $sLocal_Time)
; Split the returned date and time
$aUTC = StringSplit($sUTC_DTG, " ")
; And we have UTC time
$sUTC_Time = $aUTC[2]
ConsoleWrite($sUTC_Time & @CRLF)

Does it?

M23

[fgilain]

Seems to calculate correcly the time (1 hour less in UTC time) ..but what i really need is the "epoch datetime"...

NB : will htis work too after next daylight change ?

FG

[Melba23]

fgilain,

So write your own function to obtain epoch time - DateDiff looks like a good place to start.

I have no idea if _Date_Time_GetTimeZoneInformation takes account of the twice yearly time changes - but if you look at the Help file page for the function you can see that there is a field for daylight saving, so I imagine it probably does. You will just have to wait and see.

M23

[kylomas]

fgilain,

You could set the date/time on some PC to whatever date you want to test and watch it rollover...

kylomas