Could somebody help me how to get current timestamp in the px?
How to get current timestamp in the px
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Tue Sep 16, 2003 7:12 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you need it within the job, or when inserting data into a table?
If the latter, use the CURRENT_TIMESTAMP or CURRENT_DATE constant in custom SQL. (The name of the constant, and how you may need to manipulate it with a date picture, vary between databases.)
If the latter, use the CURRENT_TIMESTAMP or CURRENT_DATE constant in custom SQL. (The name of the constant, and how you may need to manipulate it with a date picture, vary between databases.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
If in the job, use TimeDate() and have fun reformatting it to fit your needs.
7.x is MUCH better at handling this due to the added feature of DataStage BASIC. oconv, iconv, and all the good stuff.
-T.J.
P.S. Ray -- CURRENT_DATE? That works for Oracle too? Yay! Learned something new.
7.x is MUCH better at handling this due to the added feature of DataStage BASIC. oconv, iconv, and all the good stuff.
-T.J.
P.S. Ray -- CURRENT_DATE? That works for Oracle too? Yay! Learned something new.
Developer of DataStage Parallel Engine (Orchestrate).