Page 1 of 1
date converstion
Posted: Wed Jan 23, 2008 6:26 am
by dsdv78
Hi All,
I have small doubt regarding date converstion... i want to convert string to date in transformer stage..Can any help this one...
Thanks
Posted: Wed Jan 23, 2008 7:55 am
by chulett
What is your small doubt? Have you tried using... StringToDate()?
Posted: Thu Jan 24, 2008 2:43 am
by dsdv78
Hi,
I tried string to date and also date to string...
my source contain like that.12/02/1990 0.00009
i want to in target like that.12/02/1990
Thanks
chulett wrote:What is your small doubt? Have you tried using... StringToDate()? ...
Posted: Thu Jan 24, 2008 4:37 am
by devidotcom
Your input string looks like it contains timestamp.
If yes, convert it to timestamp and then to date
Posted: Thu Jan 24, 2008 7:13 am
by AmeyJoshi14
![Idea :idea:](./images/smilies/icon_idea.gif)
You can use substring...as well
In the transformer define stage variable(varchar) and in that use substring function as :
Link.Column_name[1,10]
and assign this value of the stage variable to desired column.
Posted: Wed Feb 06, 2008 3:30 am
by gnan_gun
Here No need of Stage variable.
In Transformer target column derivation just give as inputcolumn[1, 10] and target column datatype should be date(10).