CurrentDate() Year extract

[Yizi]

Hi all, this is my first post, sorry if it's a duplicate I did do a search beforehand... I'm pretty new to DS and I'm stuck trying to extract the year part from CurrentDate() function. Below is my SQLany help is appreciated.

Code: Select all

If (lkCopyTrans.CardExp <> 'xxxx' OR lkCopyTrans.CardExp <> '') Then 
StringToTimestamp(
(If AsInteger(lkCopyTrans.CardExp[1,2]) - ( CurrentDate()-1990) < 0 Then '19' Else '20')
 : lkCopyTrans.CardExp[1,2]  : '-' :
(If Len(lkCopyTrans.CardExp[3,2]) = 2 And AsInteger(lkCopyTrans.CardExp[3,2]) >=0 and lkCopyTrans.CardExp[3,2] <= 12 Then lkCopyTrans.CardExp[3,2] Else '12')
 : '-01 00:00:00'
, "%yyyy-%mm-%dd %hh:%nn:%ss") Else
StringToTimestamp('2025-12-01 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")

I would write it like this if it was PL-SQL: DateExtract('Year',current_date)-1990)
Apologies in advance if i have broken any rules...

[EDIT - Job type changed to Parallel - Andy]

[chulett]

No worries about the rules. Yet.

So this is actually for a Parallel job and not a Server job type as posted?

[rkashyap]

DataStage Parallel transformer has a few inbuiltfunctions to help with such conversions.

YearFromDate function will extract year from a Date. For current year ... YearFromDate(CurrentDate())

[skp]

Hi,

Datastage default CurrentDate() format is %yyyy-%mm-%dd

so use below logic to extract the current year from CurrentDate() function.

Left(CurrentDate(),4)

[ray.wurlod]

Datastage default CurrentDate() format is %yyyy-%mm-%dd

This is not necessarily true. For starters, the return value is of type Date, which is a binary number. Secondly, the default format when converting to a string depends on the locale, and the default set using the Project Properties in the Administrator client.
The Left() function forces a data type conversion from date to string.