Selecting fields in SQL Select statements (Dumbest SQL Question)
- by JC
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