If the arguments are character types, the string comparison uses non-padded comparison semantics. Character comparison is binary and based on the numerical codes of the characters. The string is treated as a sequence of bytes for the comparison rather than character by character.
Timestamp comparisons are made in GMT. GMT conversion occurs if a time zone is associated with the timestamp input.
This function is CASESPECIFIC.