TimestampGetPart

TimestampGetPart

Returns one part (year, month, day, etc) of the timestamp variable.

Syntax

TimestampGetPart(TIMESTAMP Timestamp, INT Part [, INT bUtc])

Timestamp:

The timestamp from which the part will be extracted.

Part:

Indicates which part to extract:

0 – The year part

1 – The month part.

2 – The day part.

3 – The hour part.

4 – The minute part.

5 – The second part.

6 – The millisecond part.

7 - The number of milliseconds since midnight last occurred.

UTC:

Universal Time Co-ordinate (optional):

0 – The given time INTEGER is a local date/time.(default).

1 – The given time INTEGER is a UTC date/time.

Return Value

The required part of the TIMESTAMP variable.

Related Functions

Example

TIMESTAMP t1;
		// insert code here
INT year = TimestampGetPart(t1, 0);
INT second = TimestampGetPart(t1, 5);