Syntax 1 For DateTime and blob values
Description
Extracts a time value from a DateTime value or a blob.
Syntax
|
1 |
<span>Time</span> ( <span>datetime</span> ) |
|
Argument |
Description |
|---|---|
|
datetime |
A DateTime value or a blob in which the |
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:
|
1 |
DateTime StartDateTime |
|
1 |
time StartTime |
|
1 |
... |
|
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:
|
1 |
time lt_time |
|
1 |
lt_time = <span>Time</span>(BlobMid(ib_blob, 32)) |
See Also
-
Time method
for DataWindows in the DataWindow Reference or online Help