Selecting fields in SQL Select statements (Dumbest SQL Question)

Question

Hello all,

Here's a dumb question which I can't find an answer to: I have a table which contains 20 fields, a few of which are date/time. I am interested in pulling all the fields. I would like to pull the datetime fields using the to_char function but don't want to individually list out all the other fields. Is there an easy way to do this?

I tried select *, tochar(dtfield) as dt2 and select tochar(dtfield) as dt2, * and both give errors.

Thanks for all your help! JC

Answer 1

You may need to qualify the * with the table name (or alias):

select tablename.*, tochar(dtfield) ...

Answer 2

You've got no from clause that you've shared. You have to select from a table, did you just omit it in your example?