Dhida,
When you say "binary date" do you mean Julian (that is, an offset from a particular day zero)? For example, in DataStage, the "binary" form of 08/31/2000 is 11932, and day zero is 12/31/1967.
On this basis, you can calculate that your day zero is 12/31/1899 (day 1 is 01/01/1900). You can simply apply the offset (24836, the difference between the two). For example: Oconv(MyDate-24836, "D/MDY[2,2,4]")
You should also look at the Transforms and Routines in the Date branch of the SDK routines in DataStage Manager for more options and alternatives.
Regards,
Ray
> ----------
> From: Dhida Frances M. Wacnang[SMTP:dwacnang@Informix.Com]
> Sent: Friday, 20 October 2000 16:24
> To: ray.wurlod@Informix.Com; tak.chu@Informix.Com
> Subject: DS routine
>
> Guys,
>
> Would you happen to have a routine that would transform a binary
> date into a DM4 format?
>
> Sample : 36768 08/31/2000
>
>
> Thanks!
> Dhida Frances M. Wacnang
> Informix, Philippines
>
Date Offsets
Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.
Return to “Archive of DataStage Users@Oliver.com”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration