varchar to date
Moderators: chulett, rschirm, roy
varchar to date
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact:
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
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle