Unix timestamp in VB

Okay, remember these date functions?
Here is another one when asked to submit a date/time as a Unix timestamp…

Calculated in seconds from January 1st, 1970 in Visual Basic.

Public Function fncConvertToUnixTimestamp(datDate As DateTime) As Double
    Dim datOrigin As DateTime = New DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc)
    Dim diff As TimeSpan = datDate.ToUniversalTime() - datOrigin
    Return (Math.Floor(diff.TotalSeconds))
End Function

Have a nice day!

Convert between Local Time and UTC or Zulu time

Here is some visual basic code for you!
You receive a ZULU time and want to store it in your local time?

Dim MyZulu As New Date(year,month,day,hr,min,sec,DateTimeKind.Utc)
Dim MyLocal As DateTime = MyZulu.ToLocalTime()

Or is someone or some API asking you for the next format in return, and all you have is a DateTime with your local time in it?

*UTC + offset as (YYYY-MM-DDThh:mm:ss+hh:mm)
Continue reading Convert between Local Time and UTC or Zulu time

Mac time synch

Using vmware I always suspend my mac-os machine, so the time at revival is never correct… so how to force a time-synch:

source: here

10.14 Mojave

Mojave still uses timed, but ntpdate and the helpers ntpq are removed. To check and update your system time, you can call sntp directly.

$ sudo sntp -sS pool.ntp.org
Password:
sntp 4.2.8p10@1.3728-o Tue Mar 21 14:36:42 UTC 2017 (136.200.1~2533)
2018-09-29 19:42:41.448103 (-0200) +1087.742403 +/- 725.183462 pool.ntp.org 188.68.36.203 s2 no-leap

Out of the box, a tracking file is missing. So if you get the error below when checking time:

kod_init_kod_db(): Cannot open KoD db file /var/db/ntp-kod: No such file or directory

create the file and change ownership to root. Some people reported this was actually breaking the ntp synchronization.

sudo touch /var/db/ntp-kod
sudo chown root:wheel /var/db/ntp-kod

Then run again to check if the error message is gone.

sudo sntp -sS pool.ntp.org

In case you have the same issue, i used to use the following commands before, but they hasn’t worked since whatever previous os version/update:

sudo ntpd -sS time.apple.com
sudo ntpdate -u time.apple.com

Have a nice day!