Search found 2 matches
- Fri Dec 16, 2005 12:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Subtraction of dates.
- Replies: 1
- Views: 910
Subtraction of dates.
Hello, I have two dates and format is TimeStamp and the database is Oracle 10g and Data Stage 7.5.1 if I subtract the date from one date to another date, I used the following in transformation. OConv(DateTimeStampToInternal(DSLink3.milestone_date) - DateTimeStampToInternal(DSLink3.milestone_capture_...
- Fri Dec 16, 2005 12:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 11
- Views: 5891
Subtracting two Dates and the result should be in date forma
Hello, I have two dates and format is TimeStamp and the database is Oracle. if I subtract the date from one date to another date, I used the following in transformation. OConv(DateTimeStampToInternal(DSLink3.milestone_date) - DateTimeStampToInternal(DSLink3.milestone_capture_date), 'yyyy-mm-dd hh24:...