Well, maybe if I put it another way:

if I do this on my Solaris box:
shamrock% date
Wed Mar 21 15:07:54 EST 2001


How does ORACLE covert this to SYSDATE formula?
How does it ignore/erase the "EST"???


thanks,
Magnus