Oracle STANDARD_HASH result show different result while using different platform

Question

I get a problem when doing queries with different platforms using Oracle. The results of the query indicate the difference in output. First I used the "Toad for Oracle Database" application and the results like this:

The results showed perfect results, as I wanted.

But when I do queries on different platforms, namely PHP Codeigniter and Navicat (it may also apply to other platforms). The results are different as in this picture:

Following are the queries that I am trying to run but do not work on different platforms.

select STANDARD_HASH(sysdate) from dual;

Answer 1

Try adding RAWTOHEX. This will convert the returned value from a RAW to a VARCHAR2, which should be more easily understood by all SQL clients. (As Justin pointed out this is probably a client issue, not a problem with STANDARD_HASH.)

select rawtohex(standard_hash(sysdate)) the_hash from dual;

THE_HASH
----------------------------------------
FBC14021D134F922420086D291906B0B0D783421