varchar to date
Posted: Mon Aug 23, 2004 8:12 pm
hi,
stg is in varchar it need conversation in date in Datamart ,pl. advice.
Thanks,
Bobby
stg is in varchar it need conversation in date in Datamart ,pl. advice.
Thanks,
Bobby
Page 1 of 1
Posted: Tue Aug 24, 2004 12:40 am
Hire an articulate consultant.
Posted: Tue Aug 24, 2004 1:53 pm
Hi Ray,
Can this things be disccussed private budy
Can this things be disccussed private budy
Posted: Tue Aug 24, 2004 2:34 pm
Please state your problem clearly. Your question makes almost no sense. We don't like to guess at what you mean. You haven't stated database technology, format of the source date, data type of the target.
Posted: Wed Aug 25, 2004 2:06 pm
Hi,
You can use "StringToDate()" function in a PX Transformer to convert the string to a "Date" type variable. Use help for the syntax.
Regards
Amitava
You can use "StringToDate()" function in a PX Transformer to convert the string to a "Date" type variable. Use help for the syntax.
Regards
Amitava
Posted: Mon Feb 28, 2005 1:36 pm
I am using Dat stage 7.5 on unixgh_amitava wrote:Hi,
You can use "StringToDate()" function in a PX Transformer to convert the string to a "Date" type variable. Use help for the syntax.
Regards
Amitava
need to convert a varchar (40) coolumn data to timestamp (38)
StringToDate does not exist in DS
what does
thanks
Bob
Posted: Mon Feb 28, 2005 1:47 pm
Please state the format of the source data as well as the target. We don't know which timestamp you're talking about, Oracle, Sybase, DB2, etc. Plus, are you going to load it into the database using which stage? It's all important so that we can give you the right answer.
Next time, please start a new post rather than hijack an old one. On the new post, you'll be able to specify your platform, version, etc. The StringToDate() reponse is for a PX job, not Server, for which that reply is irrelevant and wrongly posted.
Next time, please start a new post rather than hijack an old one. On the new post, you'll be able to specify your platform, version, etc. The StringToDate() reponse is for a PX job, not Server, for which that reply is irrelevant and wrongly posted.
Posted: Mon Feb 28, 2005 1:49 pm
thanks Ken - I did just start a new one
varchar to date conversion in data stage 7.5 on unix
varchar to date conversion in data stage 7.5 on unix
Posted: Mon Feb 28, 2005 1:56 pm
I'm looking for it, where is it? A new post means a NEW POST, not a reply on an existing message thread.
Posted: Mon Feb 28, 2005 2:29 pm
kcbland wrote:I'm looking for it, where is it? A new post means a NEW POST, not a reply on an existing message thread.
Here it is for those reading this chain:
viewtopic.php?p=125936#125936