Skip to Content
0

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

Feb 20, 2017 at 01:27 PM

147

avatar image
Former Member

Hi,

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

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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!!
Share
10 |10000 characters needed characters left characters exceeded