Hai,
I need to lookup for date field in sequential file into the timestamp in the oracle table.How can i do that.
Ex:20060405 in sequential file to be lookup to the the
2006-04-05 00:00:00 in the oracle table
Date to Timestamp conversion in Transformer.................
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Sat Mar 18, 2006 1:53 pm
ICONV() won't work in a PX job. So you will need to convert this string date to the correct string format then use StringToDate() or a similar function or use the cast capabilities within your Oracle query.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Marked as Server in the PX forum. Who knows which it is... Only the shadow knows
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>