Date Extraction.

karry450 · Post by **karry450** » Mon Jul 14, 2008 2:36 am

Hi Friends

I have Timestamp in the format as 12/07/2008 04:00:15, I want to extract just the date part as 12/07/2008.

Do we have anyfunction to do in datastage server jobs.

Can anyone help

thanks.

ArndW · Post by **ArndW** » Mon Jul 14, 2008 3:11 am

In Server jobs the dates/timestamps are strings, so a "LEFT(In.TimestampCol,10)" or "In.TimestampCol[1,10]" will do this for you.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 3:12 am

Yes. You use substring or Field() function to extract the date portion as a string from your input value.