Unix Time

[Pathma_Mu]

Hi,

Kindly help me out from below case.

Dim Message_Time As String
Message_Time = “2016-02-27 10:16:01”

I want convert into Unix time.

[Wayne_Golding]

If you have a look at http://developer.xojo.com/xojo-core-date you’ll see you can create a new Date (you’ll have to parse the SQLDateTime yourself). The property SecondsFrom1970 should give you the unix time.

[Kem_Tekinay]

This will convert your SQL Date/Time format into Unix time:

dim rx as new RegEx
rx.SearchPattern = "\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}"
rx.ReplacementPattern = "Unix Time"

Message_Time = rx.Replace( Message_Time )

[Christian_Schmitz]

if you want the seconds since 1970, you can create new date(1970,1,1,0,0,0) and subtract total seconds from other date.

[Tim_Jones]

@249886:@Christian Schmitz

if you want the seconds since 1970, you can create new date(1970,1,1,0,0,0) and subtract total seconds from other date.

This is the way I’ve handled it forever on OS X. Apparently, the myth has it that Steve loved his mom and that’s why the 1904 date for the Apple / OS X epoch…

[DaveS]

Except Jobs biological mother was born in 1932, making her 31 when he was born, his adoptive mother was born in 1924

Steve Jobs’ 79 year-old birth mother Joanne Carole Schieble was born on 1932 in Wisconsin to Arthur and Irene Schieble.

Clara Jobs was born August 23, 1924 in New Jersey

The rationale for selecting 1904 is it was the 1st Leap year of the 20th Century

[Tim_Jones]

@250007:@Dave S

Except Jobs biological mother was born in 1932, making her 31 when he was born, his adoptive mother was born in 1924

Then I’ve no clue as to where the 1904 date came from. That story’s what I’ve always heard when I’ve asked someone at Apple…

However, a dig into Apple history via the way back machine identified this bit from Geoff Duncan:

Geoff Duncan writes, “And as for the year 2040, there’s an interesting explanation behind Apple’s odd expiration date. The original Mac development team chose midnight, January 1, 1904, as the start of the Mac calendar - in part because it’s mathematically convenient to have a calendar system start on a leap year, which 1900 was not. And since the calendar was built to cover approximately 136 years, your Mac OS won’t expire until the start of the year 2040.”

So, it’s just something that happened - even though the rest of the computing world went with variants of either Dec/31/1969 or Jan/01/1970.

[Norman_P]

No magic or mystery
It had certain nice properties
http://lowendmac.com/lab/04/0115.html

[DaveS]

FYI… I’m the same age as Steve Jobs would have been… and my late GRANDMOTHER was born in 1903

[Norman_P]

lots of fun rumors about things just like there are conspiracy theories
the truth is sometimes much more boring

[LangueR]

rumors are just that rumors, but selections are usually selected for some reason which at the time makes sense (which are usually not related to rumors - definitely not the birth or death of a person, other than Jesus that is)

https://en.wikipedia.org/wiki/Epoch_(reference_date)