DSXchange

Posted: **Thu Jun 07, 2007 1:02 pm**

Hi there,

We use TimeDate() to get both Time and date. But is there a function to get only Date or only Time?

Thanks for all your help.

Posted: **Thu Jun 07, 2007 1:07 pm**

Sure, both Date() and Time() are available.

Posted: **Thu Jun 07, 2007 1:24 pm**

Thanks Chulett,
But these functions return Date and Time in the Datastage Internal format right?

Posted: **Thu Jun 07, 2007 1:30 pm**

Yes. Are you looking for PX specific functions that return external formats?

Posted: **Thu Jun 07, 2007 1:35 pm**

CurrentDate
CurrentTime
CurrentTimestamp
all of the above are px specific solutions.

Posted: **Thu Jun 07, 2007 1:39 pm**

Thanks for all the help :D

Function to get the current date only.