getting today's date in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
getting today's date in datastage
I would like to check a date with todays date in the datastage transformer stage .Some thing in oracle like sysdate . . . How shall i get the system date in datastage .. . Is it an function or a datastage defined constant . . . could anybody give a lending hand on this topic
Regards
Ragu
Ragu
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
syntax of the function
Vijay ,
could u give me the syntax of the function provided so tat it would be helpfull to analyse the function completely
could u give me the syntax of the function provided so tat it would be helpfull to analyse the function completely
Regards
Ragu
Ragu
-
- Participant
- Posts: 13
- Joined: Fri Jul 15, 2005 12:01 am
Re: getting today's date in datastage
you can use DSJobStartTimestamp OR DSJobStartDate
Re: getting today's date in datastage
Yes. You've got both. Check the online help for:Ragunathan Gunasekaran wrote:How shall i get the system date in datastage .. . Is it an function or a datastage defined constant
Code: Select all
Date()
@DATE
Time()
@TIME
TimeDate()
So, a myriad of ways to get what you need exist.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: getting today's date in datastage
Correct, those are macros that would give you a static value, if that's what one needed.satyanarayana wrote:you can use DSJobStartTimestamp OR DSJobStartDate
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers