comparing two timestamps field

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pattemk
Participant
Posts: 84
Joined: Wed May 16, 2007 4:04 pm

comparing two timestamps field

Post by pattemk »

Hi,

I am comparing two timestamp fields(of different lengths). i am wondering if we must convert these into string and than do compare or we can just compare the timestamps. also do we have to trim before comparing if the two timestamps fields lengths are different?

Please advice

Thanks
girija
Participant
Posts: 89
Joined: Fri Mar 24, 2006 1:51 pm
Location: Hartford

Post by girija »

It is comparing to timestamp field, why do you concern about the length?
Its OK to compare two timestamp.
pattemk
Participant
Posts: 84
Joined: Wed May 16, 2007 4:04 pm

Post by pattemk »

[quote="girija"]It is comparing to timestamp field, why do you concern about the length?
Its OK to compare two timestamp.[/quote]


Thanks..i want to confirm.
Post Reply