FMDiff™   

FileMaker Business Alliance
View Winfried Huslik's profile on LinkedIn

This site is W3C compliant:
Valid XHTML - Valid CSS
Last modified May 11 2014, 18:06:35 CEST.

Timestamp Formats

How is a Timestamp represented on Mac OS and Windows?

Convert a UNIX, Macintosh, and FileMaker Pro timestamp number into date/time and vice versa

A UNIX timestamp is a number that represents the seconds passed since 1970-01-01 00:00:00. This format is also used on Windows.
On Mac OS X and 9 the count starts at 1904-01-01 00:00:00.
The FileMaker timestamp data format represents the number of seconds since 0001-01-01 00:00:00 with a range of up to 4000-12-31 23:59:59.999999

Don't let yourself be fooled by the high precision the timestamp is shown in the FileMaker Pro 8.5 Help. There is currently no means to set the fractions of a second as real time from within FileMaker. Let's put it this way: these fractions are "tolerated" by the format and the calculation engine, but the fractions are never set, only the integer part is used.

Value Submit as Format
yyyy mm dd hh mm ss
- -   : :  
Tuesday, 2014-09-02 22:46:35   (UTC)

Note: Dates out of the UNIX range (< 1901-12-13 20:45:52 or > 2038-01-19 03:14:08 UTC) may show invalid values due to the use of available PHP functions.

If you need some more confusion on time stamps, please read UNIX time in Wikipedia


Examples are provided "AS IS" without warranties of any kind. Use at your own risk.

Copyright © 2005 - 2014 Huslik Verlag GmbH. All Rights Reserved. FMDiff and FMChecker are trademarks of Huslik Verlag GmbH, Augsburg, Germany. FileMaker is a trademark of FileMaker Inc., Santa Clara, CA, USA. Other trademarks mentioned are property of their respective owners. This web site has not been authorized, sponsored, or otherwise approved by FileMaker, Inc.