How to get current timestamp in the px

prasad9202 · Post by **prasad9202** » Mon Feb 16, 2004 7:29 pm

Could somebody help me how to get current timestamp in the px?

ray.wurlod · Post by **ray.wurlod** » Mon Feb 16, 2004 8:03 pm

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.)

Teej · Post by **Teej** » Tue Feb 17, 2004 11:39 am

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.

chulett · Post by **chulett** » Tue Feb 17, 2004 1:20 pm

Teej wrote:P.S. Ray -- CURRENT_DATE? That works for Oracle too? Yay! Learned something new.

It does, but it's called 'SYSDATE'.

Teej · Post by **Teej** » Tue Feb 17, 2004 1:38 pm

Aha. I already uses that in my old PL/SQL (and Pro*C once I think) stuff. Thanks for the reminder.

-T.J.