Using the tool provided by the vendor is not exactly the same as using a database driver through any language, there are always subtle differences. My experience is more related to MySQL but it happened to me that things that in the client worked in a way, they worked differently using DBD::mysql

I agree with igelkott that you should use = operator instead of a like, and if you column is timestamp and you need to match only the date then you should cast the column like:

WHERE group_name = 'Full Network Access' AND TO_DATE(update_timestamp)
+ = sysdate
[download]