Syntax 1 For DateTime and blob values

Description

Extracts a time value from a DateTime value or a blob.

Syntax

<span>Time</span> ( <span>datetime</span> )

1	<span>Time</span> ( <span>datetime</span> )

Argument	Description
datetime	A DateTime value or a blob in which the first value is a time or DateTime value. The rest of the contents of the blob is ignored. Datetime can also be an Any variable containing a DateTime or blob.

Return Values

Time. Returns the time in datetime as
a time. If datetime does not contain a valid
time or is an incompatible datatype, Time returns
00:00:00.000000. If datetime is null, Time returns null.

Examples

After StartDateTime has been
retrieved from the database, this example sets StartTime equal
to the time in StartDateTime:

DateTime StartDateTime

1	DateTime StartDateTime

time StartTime

1	time StartTime

...

...

StartTime = <span>Time</span>(StartDateTime)

1	StartTime = <span>Time</span>(StartDateTime)

Suppose that the value of a blob variable ib_blob contains
a DateTime value beginning at byte 32. The following statement extracts
the time from the value:

time lt_time

1	time lt_time

lt_time = <span>Time</span>(BlobMid(ib_blob, 32))

1	lt_time = <span>Time</span>(BlobMid(ib_blob, 32))

Syntax 1 For DateTime and blob values – PB Docs 125