Hi All,
I want to perform the join operation on two columns of Oracle.
First column is having datatype Date and contain values in format : 7/10/2003 10:37:00 AM
Second column is having datatype Timestamp(6)
and contain value in format : 7/10/2003 12:00:00.000000 AM
when i am comparing the values from these two columns ,i am not getting any result in my outupt.
Please help me ,is there any standard function which will extract some part from these above two datatypes in specific format(i.e YYYY-MM-DD) to compare value between them or i need to build the custom transform.
Thanks In Advance!!
Comparing Two Data Values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
Comparing Two Data Values
IBM Websphere Datastage Certified Professional
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
Hi Craig,
By using to_char() function,it is working fine.
But i didn't find any proper conversion code in Incov() function to convert these two values in same format. I want to use the Datastage provided function to perform this task,because i feel by using Oracle supported function and using them in queries slightly taking more time during execution.
Thanks!!
By using to_char() function,it is working fine.
But i didn't find any proper conversion code in Incov() function to convert these two values in same format. I want to use the Datastage provided function to perform this task,because i feel by using Oracle supported function and using them in queries slightly taking more time during execution.
Thanks!!
IBM Websphere Datastage Certified Professional
The ICONV for a date function will only use the date portion, so you should truncate the timestamp, i.e.
Code: Select all
ICONV(FIELD(In.TimestampColumn,' ',1),"D4/DMY[2,2,4]")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>