convert string to timestamp am or pm
Moderators: chulett, rschirm, roy
convert string to timestamp am or pm
Hi Friends,
I have timestamp filed with varchar datatype and I need to convert it to timestamp with different format mm/dd/yyyy and hours should be 12 hrs basis am or pm.
Can any one suggest.
Thanks in advance.
Regards
Anju
I have timestamp filed with varchar datatype and I need to convert it to timestamp with different format mm/dd/yyyy and hours should be 12 hrs basis am or pm.
Can any one suggest.
Thanks in advance.
Regards
Anju
timestamp and date columns have no format. Formatting is only necessary when converting to a string type. You can do a
Code: Select all
TimeStampToString(In.TimeStampColumnName,'%mm/%dd/%yyyy %HH:%nn:%ss %aa')
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
convert string to timestamp am or pm
Yes The default format is yyyy-mm-dd hh:nn:ss.So can't I change the format with am or pm to timestamp.I tried StringToTimestamp and all.But I can not.Suggest me on this.
Thanks
Thanks
<sigh> vilasani, what happened when you tried TimeStampToString?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
convert string to timestamp am or pm
Can I use Iconv and Oconv functions.If it is so how to use those functions.
Thanks
Anju
Thanks
Anju
convert string to timestamp am or pm
Can I use Iconv and Oconv functions.If it is so how to use those functions.
Thanks
Anju
Thanks
Anju
convert string to timestamp am or pm
Can I use Iconv and Oconv functions.If it is so how to use those functions.
Thanks
Anju
Thanks
Anju
Vilasini - unless you answer the question you won't get any answers!
ICONV/ICONV don't exist in EE/PX jobs, but you posted the question in this forum so that is why nkreddy_3 asked what kind of job you have.
ICONV/ICONV don't exist in EE/PX jobs, but you posted the question in this forum so that is why nkreddy_3 asked what kind of job you have.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
convert string to timestamp am or pm
I am using parallel jobs.I have used SringToTimestamp alone it works.But I need mm/dd/yyyy with am or pm based hrs.
Any one can suggest.
Thanks
Anju.
Any one can suggest.
Thanks
Anju.
Vilasini - I now give up.
You won't post what you have tried and what the results are when things don't work.
I gave you a transform stage derivation that will work (since I tested it), but you seem to prefer to ignore minor matters like that so I wish you luck in getting this solved.
You won't post what you have tried and what the results are when things don't work.
I gave you a transform stage derivation that will work (since I tested it), but you seem to prefer to ignore minor matters like that so I wish you luck in getting this solved.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>