Re: [GENERAL] Formatting TimeStamp

2005-09-08 Thread Philip Hallstrom
Joshua, I know that i can format it explicitly, but instead of using a SELECT * FROM .. I have to name the columns which is not very convenient. Right now I have created views for each table just to re-format the output of the one timestamp field. Not sure it solves your problem, but you can

Re: [GENERAL] Formatting TimeStamp

2005-09-08 Thread Joshua D. Drake
Alex wrote: Hi, I am using the timestamp various tables but dont like to see the microseconds. Is there way to format the output of timestamp fields globally (in the postgres.conf)? Preferably i only would like to see the MMDD HH:MM:SS. Or can a formatting be passed to a SELECT * hm