http://xataface.com/wiki/index.php?-action=single_record_search&-table=wiki&page_id=%3D44&-cursor=0&-skip=0&-limit=30&-mode=list&--subsearch= Wed, 19 Jun 2013 18:18:50 +0100 FeedCreator 1.7.2 http://www.xataface.com/wiki/timestamp <table><thead><tr><th>Field</th><th>Value</th></tr></thead><tbody><tr><td valign="top">Page name</td><td valign="top">timestamp</td></tr><tr><td valign="top">Page id</td><td valign="top">44</td></tr><tr><td valign="top">Page title</td><td valign="top">timestamp</td></tr><tr><td valign="top">Content</td><td valign="top"><p>Return to <a href="/wiki/fields.ini_file">fields.ini file</a></p> <p>A very simple sample of this could be your table contains the table date_created as a type of date. In your fields.ini, you would include this:</p> <pre><code>[date_created] timestamp=insert widget:type=hidden</code></pre> <p>The widget:type=hidden will make the field not visible during entry and editing. And the timestamp=insert causes the field to be filled upon insertion of a new record.</p> <h3 id="toc0">Possible Values</h3> <ul> <li> <strong>update</strong> - Causes timestamp to be updated whenever the record is modified.</li> <li> <strong>insert</strong> - Causes the timestamp to be updated only when the record is first inserted.</li> </ul> </td></tr><tr><td valign="top">Keywords</td><td valign="top">timestamp, date, datetime</td></tr><tr><td valign="top">Language</td><td valign="top">en</td></tr></tbody></table> timestamp