Formatting TimeStamp

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.

Mysql for example has a in addition to the TIMESTAMP also a DATETIME
type that returns |'YYYY-MM-DD HH:MM:SS'. So, I was wondering if there
is anything similar in postgres or can i set the precision or format of
the timestamp in the postgres.conf or can I define a new type.

Alex

|
Joshua D. Drake wrote:

> 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 YYYYMMDD HH:MM:SS.
>>
>> Or can a formatting be passed to a SELECT * .... hmmm probably not.
>
>
> http://www.postgresql.org/docs/8.0/static/functions-datetime.html
>
> And yes you can do it in a SELECT.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>>
>> Thanks for any advise
>>
>> A
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>
>
>