Re: SQL Problems

Posted and mailed.

Not sure that I understand your question, Francis. I also have no idea of your experience level, so pardon me if this is too elementary. If you want to see system time, then:

SELECT TO_CHAR( sysdate, 'hh24:mi:ss') FROM dual;

will show you the time in 24-hour mode, hours, minutes and seconds.

SELECT TO_CHAR( sysdate, 'hh:mi:ss am') FROM dual;

will show 12-hour, am/pm format. Is this what you wanted?

Chris

Francis wrote in message <370a2275.48512587_at_bbinews.netvigator.com>...
>I am using Oracle SQL*Plus now, how to compare the field with the
>system time?
Received on Thu Apr 08 1999 - 05:51:50 CEST