The date_fields table

date_fields is used to store the date of all messages.

The date stored is specified by the message sender. There is precisely one date per message. If a message contains two dates (as e.g. forwarded messages often do), then the outer date is used (the forwarding message's date rather than the forwarded messages's date).

A date is stored as a native PostgreSQL timestamp. Archiveopteryx converts back and forth between SQL and email formats as needed.

create table date_fields ( -- Grant: select, insert message integer not null references messages(id) on delete cascade, value timestamp with time zone );

The date_fields table was introduced in version 1.08.

In case of questions, please write to info@aox.org.

Relevant links

About this page

Last modified: 2010-11-19
Location: aox.org/db/date_fields