Type Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
Type Conversion
some of the values in column are coming as 1.00088e+06 I want it to convert it in a number/numeric format . so can I do this ?
job is
odbc stage --->transfrmer----->odbc stage
job is
odbc stage --->transfrmer----->odbc stage
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
If you are reading this from a file or converting from a string, just declare your data type a float and you are good to go.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
In that case, you should have no problems. The notation in the e-exponent form is just when you display the data.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
ketanshah123 - have you actually looked at the manual? In the functions appendix of the Parallel Job Developer's Guide there are CAST functions which you can use.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>