Defaulting the century when use StrinToTrimStamp

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Derrickfn
Participant
Posts: 11
Joined: Fri Jul 18, 2008 4:07 pm
Location: Alexandria

Defaulting the century when use StrinToTrimStamp

Post by Derrickfn »

I have a date in the format of yymm, It there anyway of getting the StringToTimestamp function to default the century properly. When you don't specify the century, it always uses 19. If the year part is greater than 50 I would want it to use 19. Otherwise it should use 20.

StringToTimestamp(DSLink4.fd1,"%yy%mm")

Using a transformer is there a quick and easy way of making it do the right thing.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's controlled by CENTURYPIVOT - seach here and in the documentation for the details of its usage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply