Syntax 1: For DateTime and blob values
Description
Extracts a time value from a DateTime value or a blob.
Syntax
|
1 |
Time ( datetime ) |
|
Argument |
Description |
|---|---|
|
datetime |
A DateTime value or a blob in which the first value is a |
Return value
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:
|
1 2 3 4 |
DateTime StartDateTime time StartTime ... StartTime = Time(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:
|
1 2 |
time lt_time lt_time = Time(BlobMid(ib_blob, 32)) |
See also
Time method for DataWindows in the section called “Time” in DataWindow Reference.