BEGIN

Valid for

Extract, Replicat

Description

Use BEGIN to specify a date and time at which to start capturing data. Any record with a timestamp greater than or equal to the time specified by BEGIN that satisfies other criteria is extracted.

SPECIALRUN uses BEGIN to determine its start date and time.

Syntax

BEGIN date time[:seconds][.centiseconds]

date: The date in yyyy-mm-dd format.
time: The time in hh:mm format.
seconds: You can optionally specify seconds with the time option, as in hh:mm:ss.
centiseconds: You can optionally specify centiseconds seconds with the time and seconds options, as in hh:mm:ss.cccccc.

Examples

Example 1: BEGIN 2010-08-12 08:00 specifies a timestamp for August 12, 2010 at 8:00 AM.
Example 2: BEGIN 2010-08-12 08:00:30.000030 specifies a timestamp for August 12, 2010 at 8:00:30.000030 AM.