Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Odd sysdate construction

Odd sysdate construction

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 12 Jan 2005 13:10:13 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860760144F239@enhbgpri11.backup>


select SYSDATE@! from dual;
This appeared in a client query (actually it was trunc(sysdate@!) ) What is the @!? Its valid in the Oracle takes it but I can't find any = documentation as to what it is. It seems to act the same as plain old = sysdate. But it's the only place where @! Is allowed.

Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 12 2005 - 12:14:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US