HPART: Retrieving a Date-Time Component as a Numeric Value

How to:

The HPART function extracts a specified component from a date-time value and returns it in numeric format.

Syntax: How to Retrieve a Date-Time Component in Numeric Format

HPART(datetime, 'component', output)

where:

datetime

Date-time

Is the date-time value from which the component is to be extracted.

component

Alphanumeric

Is the name of the component to be retrieved enclosed in single quotation marks.

output

Integer

WebFOCUS

Feedback