2 Replies Latest reply on Jan 2, 2020 7:56 PM by Rodrigo Radtke Souza

<@=odiRef.getSysDate("MMddYYYY") @> is returning wrong year where to check

1396531 Dec 30, 2019 8:59 PM

<@=odiRef.getSysDate("MMddYYYY") @> is returning wrong year the day and month looks good but year is return as 2020 even though it is 2019, could you please help me with the checkpoints how to triage this issue

1. Re: <@=odiRef.getSysDate("MMddYYYY") @> is returning wrong year where to check

Adrian_Popescu-Oracle Jan 1, 2020 5:58 PM (in response to 1396531)

Hi,
This can't be wrong as it is the date provided by the operating system.
Maybe database server is on another timezone.
Hence check time zones of your servers.
Adrian
Like Show 0 Likes(0)

Actions
2. Re: <@=odiRef.getSysDate("MMddYYYY") @> is returning wrong year where to check

Rodrigo Radtke Souza Jan 2, 2020 7:56 PM (in response to 1396531)

Please check the below post. It depends on which substitution tag you are using. In your case, the @ will generate the value based on the agent server,

https://devepm.com/2014/09/16/odi-substitution-tags-demystified/
Like Show 0 Likes(0)

Actions

Go to original post