varchar to date

bobby · Post by **bobby** » Mon Aug 23, 2004 8:12 pm

hi,
stg is in varchar it need conversation in date in Datamart ,pl. advice.
Thanks,
Bobby

ray.wurlod · Post by **ray.wurlod** » Tue Aug 24, 2004 12:40 am

Hire an articulate consultant.

bobby · Post by **bobby** » Tue Aug 24, 2004 1:53 pm

Hi Ray,
Can this things be disccussed private budy

kcbland · Post by **kcbland** » 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.

gh_amitava · Post by **gh_amitava** » 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

RC99 · Post by **RC99** » Mon Feb 28, 2005 1:36 pm

gh_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

I am using Dat stage 7.5 on unix
need to convert a varchar (40) coolumn data to timestamp (38)

StringToDate does not exist in DS
what does
thanks

Bob

kcbland · Post by **kcbland** » 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.

RC99 · Post by **RC99** » 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

kcbland · Post by **kcbland** » 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.

kcbland · Post by **kcbland** » 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