Function reference
Combines a date and a time value into a DateTime value.

DateTime ( date {, time } )

Argument Description
date A valid date (such as Jan 1, 2005, or 12-31-99) or a blob variable whose first value is a date that you want included in the value returned by DateTime.
time (optional) A valid time (such as 8am or 10:25:23:456799). If you include a time, only the hour portion is required. If you omit am or pm, the hour is determined according to the 24-hour clock.

Data type: DateTime
Returns a DateTime value based on the values in date and optionally time. If time is omitted, DateTime uses 00:00:00.000000 (midnight).

Examples

DateTime(‘2013-12-28’, ’10:03:58.1234’) DateTime(Date(‘2013-12-28’), Time(‘10:03:58.1234’))

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment