date format conversion

raji · Post by **raji** » Thu May 25, 2006 11:13 pm

Hi all,

I have to convert the date format "yyyy-mm-dd" to "dd-mon-yyyy"

where my job looks like

SEQ.FILE----- TRANSFORMER STAGE----- SEQ.FILE

Please anybody help me out.

Thanks in advance

sb_akarmarkar · Post by **sb_akarmarkar** » Thu May 25, 2006 11:16 pm

Your job type is parallel and you posted your query in server jobs...

Thanks,
Anupam

raji · Post by **raji** » Thu May 25, 2006 11:53 pm

Thank u...........

how can i move to particular forum

balajisr · Post by **balajisr** » Fri May 26, 2006 12:01 am

I do not think you will have rights to mv the post to parallel forum. You can request the moderator to mv to parallel forum. When you are posting make sure that you post in the right forum.

(moderator changed to mv, prevents this post from showing in my search for posts to mv around)

kumar_s · Post by **kumar_s** » Fri May 26, 2006 9:42 am

It is marked duplicate in other post. Hence I belive Moderater can move this one to Parallel and can delete the other post.

Raji - Try StringToDate() function. What is you input stage. If is sequential file, read the input data field as varchar and use StirngToDate in the transformer.