This is really weird.
I have a very simple SQL-based variable to return a date format:
SELECT TO_CHAR(SYSDATE,‘YYYY-MM-DD’) FROM DUAL
When I run this in a TDA editor, I get the expected value of ‘2012-04-03’ (for today).
But when I run this in the automated script, it sets the value to ‘2005’. It appears that the automation is subtracting the MM and DD from the YYYY when setting the value of the variable.
I’m going to go out on a limb and say this shouldn’t be happening?