Column alias after function?

[shagymoe]

I am wondering how to include the column name as an alias after performing the to_char function. Here is the query:

select seq_number AS SEQUENCE, ref_code AS PART_NUMBER, to_char(insert_date, 'HH24:MI DD-MON-YY')AS DATE from table where ref_code like '5555555';

The "AS DATE" part returns an error. If I take it out, the other column headings get the alias...so I'm wondering how to give the insert_date column an alias in the report.

Thanks.

 

[BJCooperIT]

DATE is a reserved word. Try a different alias.

Good luck!

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
[sup]When posting code, please use TGML for readability. Thanks![sup]

 

[swampBoogie]

select seq_number AS SEQUENCE, ref_code AS PART_NUMBER, to_char(insert_date, 'HH24:MI DD-MON-YY')AS "DATE" from table where ref_code like '5555555'

 

[shagymoe]

Thanks....it didn't occur to me, but should have.