Manual:Timestamp

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

The format of timestamps used in MediaWiki URLs and in some of the MediaWiki database fields is yyyymmddhhmmss. For example, the timestamp for 2025-01-09 02:34:27 (UTC) is 20250109023427. The timezone for these timestamps is UTC.

MediaWiki's wfTimestamp() function provides a convenient way to convert from timestamps in common formats to the MediaWiki timestamp format and vice versa. Read Manual:wfTimestamp for more details. Never use wfTimestamp() when inserting a timestamp into the database; this will break in PostgreSQL and possibly other non-MySQL databases. Instead use DatabaseBase::timestamp(), aka $dbw->timestamp(), which converts a timestamp in one of the formats accepted by wfTimestamp() to the format used for inserting into timestamp fields in this DBMS.

wfTimestampNow() is a convenience function that returns a MediaWiki timestamp for the present time.

MediaWiki stores timestamps as strings rather than native timestamp types because MySQL's TIMESTAMP type had major limitations when MediaWiki was first written.^[1]