Hello Gurus
I am trying to compare two timestamp fields in a stage variable,
in.timestampfield < lkp.timestamp field ?
When I do a comparisons directly by above condition i am not seeing the desired result
I tried to search the forum with the key word "compare timestamp"
but could nt see any post addressing my issue
Any pointers ?
Thanks
Comparing two timestamp fields in transformer
Moderators: chulett, rschirm, roy
Hopefully i am understanding your question correctly
I have an input.timestamp field which i am comparing with a lookup.timestamp field
Both are having the same format
'YYYY-MM-DD HH24:MI:SS'
both the fields are pulled up by converting into char
TO_CHAR(inputtimestampfield, 'YYYY-MM-DD HH24:MI:SS'),
I have an input.timestamp field which i am comparing with a lookup.timestamp field
Both are having the same format
'YYYY-MM-DD HH24:MI:SS'
both the fields are pulled up by converting into char
TO_CHAR(inputtimestampfield, 'YYYY-MM-DD HH24:MI:SS'),
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Cool. Then they can be compared with comparison operators, for example
The ISO8601 format (which uses a 24 hour clock) for timestamps sorts and compares correctly when the timestamp is represented as a string.
Code: Select all
InLink.Timestamp1 = InLink.Timestamp2
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.