Regarding DATE.TAG function

G SHIVARANJANI · Post by **G SHIVARANJANI** » Wed Jul 11, 2007 4:36 am

Hi,

How to use the function DATE.TAG to get the system date in datastage (in transformer) ?

Thanks,

kumar_j · Post by **kumar_j** » Wed Jul 11, 2007 4:43 am

U should have the BASIC Transformer(parallel jobs) to work on it,

In server job ,we have the Build-in functions.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Wed Jul 11, 2007 5:03 am

How to get the system date in datastage (parallel jobs)

kumar_j · Post by **kumar_j** » Wed Jul 11, 2007 5:09 am

DSJobStartDate ,

by using this macro,

ray.wurlod · Post by **ray.wurlod** » Wed Jul 11, 2007 9:58 am

Why not just use the CurrentDate() or CurrentTimestamp() function?

DATE.TAG is for server jobs.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Thu Jul 12, 2007 12:38 am

What will be the date format if its currentdate()

or else DSJobStartDate ?

ArndW · Post by **ArndW** » Thu Jul 12, 2007 12:48 am

Both return an SQL date type value.