Interested to Buy Any Domain ? << Click Here >> for more details...
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?
- 4 Answers
- 25158 Views
- ME, I also Faced
- E-Mail Answers
Answer Posted / subhash
there many ways to get the SYSDATE:
1) By using the SYSDATE in the select query of your Oracle
Source.
2) By using the DsMacro, the function "DsJobstartDate " in
the transformer.
3) By using Date & Time function - "CurrentDate()" in the
transformer.
4) You would use the Date() function, and then some
variation of the OConv() function to change the date from
internal to external format.
For example, say you want to assign the current date to a
variable called StartDate, and format it in yyyy/mm/dd
format, you would use:
StartDate = Oconv(Date(), "D4/YMD")
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the use of datastage director?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Is it possible to query a hash file?
What is meta stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Can we use target hash file as a lookup ?
What are the stages in datastage?
sed,awk,head
What is the use of datastage designer?
What is staging variable?
What is difference between join, merge and lookup stage?
What are some different alternative commands associated with "dsjob"?
Differentiate between odbc and drs stage?
What are stage variables?
