Converting Date format

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dvpawankumar
Participant
Posts: 46
Joined: Fri Oct 06, 2006 6:36 am
Location: Tucson

Converting Date format

Post by dvpawankumar »

Send the Deatailed solution for Converting Source Date format "MMDDYY "to "YYMMDD".
vijayrc
Participant
Posts: 197
Joined: Sun Apr 02, 2006 10:31 am
Location: NJ

Re: Converting Date format

Post by vijayrc »

dvpawankumar wrote:Send the Deatailed solution for Converting Source Date format "MMDDYY "to "YYMMDD".
you are ordering here for a solution rather than requesting :twisted:
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Send the Detailed problem you are having converting Source Date format "MMDDYY" to "YYMMDD". What have you tried? :?

Search the forum for examples of the StringToDate function.

ps. Your additional info line and post body don't match as to what you are trying to do.
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I love posts like these, makes me laugh. Especially after Craig has answered to it, :lol:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: Converting Date format

Post by ray.wurlod »

dvpawankumar wrote:Send the Deatailed solution for Converting Source Date format "MMDDYY "to "YYMMDD".
OK, I've sent it. But I'm not telling you where.
:roll:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vijayrc
Participant
Posts: 197
Joined: Sun Apr 02, 2006 10:31 am
Location: NJ

Re: Converting Date format

Post by vijayrc »

dvpawankumar wrote:Send the Deatailed solution for Converting Source Date format "MMDDYY "to "YYMMDD".
Here's the Command:
Please change my Input Date format("MMDDYY","YYMMDD")

:)
prasadduvasi
Participant
Posts: 19
Joined: Wed Feb 15, 2006 11:08 am

Post by prasadduvasi »

Thats not correct!

Here is my answer:

Please_Convert_My_Date("MMDDYY","CCYYMMDD")
Prasad Duvasi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Surely both these functions require the date to be converted as an additional argument?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply