Reporting Language > Date-Time Functions > HDTTM: Converting a Date Value to a Date-Time Value

HDTTM: Converting a Date Value to a Date-Time Value

How to:

The HDTTM function converts a date value to a date-time value. The time portion is set to midnight.

Syntax: How to Convert a Date Value to a Date-Time Value 

HDTTM(date, length, output)

where:

date

Date

Is the date to be converted. It must be a full component format date. For example, it can be MDYY or YYJUL.

length

Integer

Is the length of the returned date-time value. Valid values are:

  • 8 indicates a time value that includes milliseconds.
  • 10 indicates a time value that includes microseconds.
  • 12 indicates a time value that includes nanoseconds.
output

Date-time

Is the generated date-time value. The value must have a date-time format (data type H).

WebFOCUS

Feedback