Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #3529 > unrolled thread

Timestamp starting 1970

Back to article view | Back to comp.databases.filemaker

Contents

  Timestamp starting 1970 Christoph Kaufmann <clkaufmann@gmx.ch> - 2023-02-01 20:43 +0100
    Re: Timestamp starting 1970 kurtz le pirate <kurtzlepirate@free.fr> - 2023-11-17 15:49 +0100

#3529 — Timestamp starting 1970

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

[toc] | [next] | [standalone]

#3540

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web