Odd sysdate construction

  • From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
  • To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Jan 2005 13:10:13 -0500

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


Other related posts: