DSXchange

Hi,

I need to get number of days between two dates in transformer. One of them is having format: 12/25/2009 and other one is like 1/21/2000 12:00:00.000000 AM.

Basically I need to implement TRUNC(DATE) functionality of Oracle.

FYI - that function returns just the date from a DATE field which is an Oracle data type that includes the time. Technically it returns the date with the time set to midnight so again (technically) they are equivalent when your time portion is set to midnight.

Since you are mentioning their "format" are they both actually strings? Or is one a Date and one a Timestamp? I mean those actual data types in the job, not just varchar fields that look like that.

In either case, look into the DaysSinceFromDate function.

Thanks Craig. It helped.