Manipulates DateTime values. There are two syntaxes.
Description
Combines a date value and a time value into a DateTime value.
Syntax
DateTime ( date {, time } )
|
Argument |
Description |
|---|---|
|
date |
A value of type date. |
|
time (optional) |
A value of type time. If you omit time, PowerBuilder sets time to 00:00:00.000000 (midnight). If you specify time, only the hour portion is required. |
Return value
DateTime.
Returns a DateTime value based on the values in date and optionally time. If any argument's value 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
These statements convert the date and time stored in ld_OrderDate and lt_OrderTime to a DateTime value that can be used to update the database:
DateTime ldt_OrderDateTime date ld_OrderDate time lt_OrderTime ld_OrderDate = Date(sle_orderdate.Text) lt_OrderTime = Time(sle_ordertime.Text) ldt_OrderDateTime = DateTime( & ld_OrderDate, lt_OrderTime)
See also
DateTime method for DataWindows in the section called “DateTime” in DataWindow Reference
Description
Extracts a DateTime value from a blob.
Syntax
DateTime ( blob )
|
Argument |
Description |
|---|---|
|
blob |
A blob in which the first value is a DateTime value. The rest of the contents of the blob is ignored. Blob can also be an Any variable containing a blob. |
Return value
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):
DateTime dt dt = DateTime(BlobMid(lb_blob, 20, 40))
See also
