how to find diff between 2 dates without using Icon...
funtions?

Answer Posted / subbuchamala

This function returns number of days from source date to the given date.

DaysSinceFromDate(mylink.sourcedate, mylink.givendate)--->No of days.

Ex:
DaysSinceFromDate(“2014-06-10”,”2014-06-15”)= 5

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of hash files are there?

610


What are the processing stages?

640


What are some prerequisites for datastage?

617


Can you explain link buffering?

724


What is the process of killing a job in datastage?

589






What is datastage engine?

730


How many types of stage?

673


Difference between data warehousing and olap?

650


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2309


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3263


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1896


What is the difference between passive stage and active stage?

822


Is it possible to query a hash file?

1561


How can we improve the performance in datastage?

647


What are the components of ascential data stage?

647