Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Timestamp starting 1970

15 views
Skip to first unread message

Christoph Kaufmann

unread,
Feb 1, 2023, 2:43:03 PM2/1/23
to
I reveived a sample csv file from some web form (not iwp) with a field
"CreationDate" with the value 1675255462 in it.

I assume its the same sort of timestamp filemaker uses, but starting at
01/01/1970 rather than 01/01/0001 like Filemaker does - that makes it
Feb 1st, 2023, 12h44, which is a plausible creation time or this sample.

Are there databases using timestamps as seconds after 1st January, 1970,
00h00?
--
TIA
Christoph Kaufmann
https://clk.ch

kurtz le pirate

unread,
Nov 17, 2023, 9:49:12 AM11/17/23
to
On 01/02/2023 20:43, Christoph Kaufmann wrote:
> I reveived a sample csv file from some web form (not iwp) with a field
> "CreationDate" with the value 1675255462 in it.
>
> I assume its the same sort of timestamp filemaker uses, but starting at
> 01/01/1970 rather than 01/01/0001 like Filemaker does - that makes it
> Feb 1st, 2023, 12h44, which is a plausible creation time or this sample.

Yes, 01/01/1970 00:00:00 UTC is the origin of timestamp for Unix
systems. FM does not respect this standard and uses its own origin.

Generally speaking, databases are managed on unix systems and therefore
use 01/01/1970.


>
> Are there databases using timestamps as seconds after 1st January,
> 1970, 00h00?
>

... maybe, but to what end ?




--
kurtz le pirate
compagnie de la banquise
0 new messages