Skip to Content
avatar image
Former Member

How to get Year of SYSDATE() in HCI-DS

Hi,

Could you please help me to get, Year of SYSDATE() in HCI-DS for the output field?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 06, 2017 at 06:43 PM

    Hi Sree,

    use year(date)

    Returns the year number of the input date. Parameters: IN date: The date whose year is to be extracted. Return type: intyou can use it as year(sysdate())Thanks!!
    Add comment
    10|10000 characters needed characters exceeded