cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member223435
Participant
0 Kudos

Hi,

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

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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!!