conversion of date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Fri Dec 21, 2007 3:24 am
conversion of date
is there any other way other than routine to convert date from mm-dd-yy to dd-mm-yy in server job
balaji
Re: conversion of date
you can use inbuilt function provided by datastage like "ICONV" and "OCONV"
there are many ways, depending on how much you can trust your date-data.
If MyDate is your Field
a
Mydate[4,3]:Mydate[1,3]:Mydate[7,2]
is just an other way without routine and inbuilt function.
If MyDate is your Field
a
Mydate[4,3]:Mydate[1,3]:Mydate[7,2]
is just an other way without routine and inbuilt function.
Last edited by WoMaWil on Fri Mar 28, 2008 6:39 am, edited 1 time in total.
Wolfgang Hürter
Amsterdam
Amsterdam