Syntax 2 For extracting DateTime values from blobs
Description
Extracts a DateTime value from a blob.
Syntax
|
1 |
<span>DateTime</span> ( <span>blob</span> ) |
|
Argument |
Description |
|---|---|
|
blob |
A blob in which the first value is a |
Return Values
DateTime. Returns the DateTime value
stored in blob. If blob is null, DateTime returns null.
Usage
DateTime data is used only for reading and writing DateTime
values to and from a database. To use the date and time values in
scripts, use the Date and Time functions
to assign values to date and time variables.
Examples
After assigning blob data from the database to lb_blob,
the following example obtains the DateTime value stored at position
20 in the blob (the length you specify for BlobMid must
be at least as long as the DateTime value but can be longer):
|
1 |
DateTime dt |
|
1 |
dt = <span>DateTime</span>(BlobMid(lb_blob, 20, 40)) |