I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDA

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?

Question Posted / k.k.ram

4 Answers
24934 Views
ME, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / ramesh

In DsMacro the function "DsJobstartDate " is there, by
using this we can recall sysdate

Is This Answer Correct ?

7 Yes

1 No

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / 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

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / kpk

if i were you i would use a function in the transformer stage.

Is This Answer Correct ?

2 Yes

1 No

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / palgun

CurrentDate()

U can find many more functions in the transformer stage....

Is This Answer Correct ?

2 Yes

1 No

Post New Answer