HNAME: Retrieving a Date-Time Component in Alphanumeric Format

How to:

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

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

HNAME(datetime, 'component', output)

where:

datetime

Date-time

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

component

Alphanumeric

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

output

Alphanumeric, at least A2

The function converts a month argument to an abbreviation of the month name and converts and all other components to strings of digits only. The year is always four digits, and the hour assumes the 24-hour system.

WebFOCUS

Feedback