Syntax 1 For creating DateTime values
Description
Combines a date value and a time value into a DateTime value.
Syntax
|
1 |
<span>DateTime</span> ( <span>date</span> {, <span>time</span> <span></span>} ) |
|
Argument |
Description |
|---|---|
|
date |
A value of type date. |
|
time |
A value of type time. |
Return Values
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:
|
1 |
DateTime ldt_OrderDateTime |
|
1 |
date ld_OrderDate |
|
1 |
time lt_OrderTime |
|
1 |
|
1 |
ld_OrderDate = Date(sle_orderdate.Text) |
|
1 |
lt_OrderTime = Time(sle_ordertime.Text) |
|
1 |
ldt_OrderDateTime <span>=</span> <span>DateTime</span>( & |
|
1 |
<span></span> ld_OrderDate, lt_OrderTime) |