SET TIMESTAMP

From Recital Documentation Wiki
Revision as of 16:53, 13 January 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Purpose

Enable a timestamp to be inserted into the specified field as a record is being appended


Syntax

SET TIMESTAMP TO <fieldname>


See Also

APPEND, CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, INSERT, SET TIMELINE, SYSTIMELINE, TIME(), TIMEOFDAY()


Description

The SET TIMESTAMP command defines a field in the current table to be used as a timestamp. When records are subsequently added to the table, the current system time will be inserted into the <fieldname> field.


Example

open database southwind
alter table example add column timeref char(8)
use example
set timestamp to timeref
// timeref field will be populated with current system time
append blank
use
// timeref field will be populated with current system time
insert into example (account_no, last_name) values ("99999", "Smith")


Products

Recital, Recital Server