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

Home -> Community -> Usenet -> c.d.o.misc -> Re: add sysdate to column name

Re: add sysdate to column name

From: alex <sql_aid_at_yahoo.com>
Date: Thu, 27 Sep 2007 09:22:30 -0700
Message-ID: <1190910150.784696.68110@d55g2000hsg.googlegroups.com>


On Sep 27, 12:12 pm, vitalis..._at_gmail.com (Jerome Vitalis) wrote:
> alex wrote:
> > Hello experts,
> > i'm attempting to add the sysdate to (not the record) but as the
> > column name.
> > something like select record as sysdate.
> > i'm getting an error, however.
> > is this possible?
>
> Yes, with something like this:
>
> select 'foo' "sysdate" from dual;
> -----
> échangez opinions et commentaires dans les forums de discussion.http://www.usenetgratuit.com/

"sysdate" is returning the name "SYSDATE" i'm looking for the system's date to become the name of the column Received on Thu Sep 27 2007 - 11:22:30 CDT

Original text of this message

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