current system date
Posted: Sat Feb 28, 2004 12:25 pm
how to add current sysdate in my target table..???
Thanks in advance
Thanks in advance
Page 1 of 1
Posted: Sat Feb 28, 2004 12:54 pm
Do a search this has been covered a lot. Within DataStage @date or date() are used. You can also use the sysdate with Oracle and other databases. To make a timestamp you will also need @time and time().
Posted: Sat Feb 28, 2004 3:09 pm
Hmmm... didn't catch you had already answered this, Kim. I thought only ADN had multiple posts. 