Is "SELECT *, Date" possible? 1

[Sandman83]

Hi All,

I am trying to write a query that will select all fields from a table (without puting each field in the select statement) and add an addition field that converts the the date from the database format to a date format. I have tried the following, but get a "keyword not found where expected" error.

SELECT *, TO_DATE(lpad(term_date - 1000000, 6, 0), 'yymmdd') "Term Date"
FROM calldetail
WHERE term_date = 1060420

I have test the "TO_DATE" code and it works fine.

Thanks,
Tim

 

[r937]

i dunno about the TO_DATE and LPAD functions, but as far as your question is concerned, yes, you can say

SELECT *, somefunction(...) ...

r937.com | rudy.ca

 

[unclejimbob]

I always thought that the '*' option was mutually exclusive to all the other select list options; i.e. you can use '*' or you can specify individual columns/functions/expressions but not both - am I wrong ?

 

[swampBoogie]

Standard SQL does not (currently) allow

select *,expressions ...
from t ...

use

select t.*,expressions ...
from t ...

 

[Sandman83]

Thanks swampBoogie. I changed to

SELECT [b][green]a.[/green][/b]*, TO_DATE(lpad([b][green]a.[/green][/b]term_date - 1000000, 6, 0), 'yymmdd') "Term Date"
FROM calldetail [b][green]a[/green][/b]
WHERE [b][green]a.[/green][/b]term_date = 1060420

and that worked perfectly.