I WANT TO KNOW ABOUT A DATE FUNCTION

amprabhu81 · Post by **amprabhu81** » Mon May 16, 2005 1:00 am

SO CAN U PLEASE TELL ABOUT A DATE FUNCTION (TAG.TO.DATE) SO IAM GETTING A DIFF ANSWER WHEN I INCLUDE THAT FUNCTION , SO CAN ANYONE PLZ TEL WHAT THAT ROUTINE EXACTLY DO .

Luk · Post by **Luk** » Mon May 16, 2005 1:22 am

hi!

it Converts a string in format YYYY-MM-DD to a numeric internal date,
for example:
TAG.TO.DATE("1993-02-14")=> 9177

(see DS Server Jobs Developer guide page 20-4)

Internal date - it is number of days since 31 December 1967 (day 0)

talk2shaanc · Post by **talk2shaanc** » Mon May 16, 2005 2:02 am

Prabhu,

whenever you have question on any in-built Routines or Transforms , like; what operation a particular routine is doing?
what should be the input or input format?
what would be the output or output format?
etc.. etc..

Just go to DataStage Manager and open that routine, you will find detailed description. You can also see the code of that routine/transform.

ray.wurlod · Post by **ray.wurlod** » Mon May 16, 2005 2:32 am

... and please note that shouting (all capitals) is regarded universally on the Internet as rudeness.