Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: add sysdate to column name
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
![]() |
![]() |