Page 1 of 1
I WANT TO KNOW ABOUT A DATE FUNCTION
Posted: Mon May 16, 2005 1:00 am
by amprabhu81
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 .
Posted: Mon May 16, 2005 1:22 am
by Luk
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)
Posted: Mon May 16, 2005 2:02 am
by talk2shaanc
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.
Posted: Mon May 16, 2005 2:32 am
by ray.wurlod
... and please note that shouting (all capitals) is regarded universally on the Internet as rudeness.