Parameters (Date, Time);
Returns: Timestamp;
Function to add a date and time together to create a dateTime (Timestamp)
The first parameter is the date. This should be a source field reference of type 'date' or a string value with the format 'yyyy-MM-dd'
The second parameter is the time. This should be a source field reference of type 'time' or a string value with the format 'HH:mm:ss'
The examples below show the characters that can be used in the pattern.
Example:
CREATEDATETIME([date],[time]) where [date] has a value of '1st Jan 2019', [time] has a value of '17:00:00'
Result:
2019-01-01 17:00:00
All times are assumed to be Universal Coordinated Time.
Comments
0 comments
Please sign in to leave a comment.