date function

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
rmeenakumari822
Participant
Posts: 30
Joined: Sat Oct 25, 2008 9:09 pm
Location: chennai

date function

Post by rmeenakumari822 »

Hi,

i have a string as 20050920 in date type
how to convert date string to 20/9/2005

what date function should be used?
priya
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

StringToDate.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

... with appropriate date format string, for example "%yyyy%mm%dd"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “General”