Re: timestamp default values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brendan Jurd <direvus(at)gmail(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp default values
Date: 2005-08-07 03:40:23
Message-ID: 28863.1123386023@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brendan Jurd <direvus(at)gmail(dot)com> writes:
> Are there any good reasons why the output of timeofday() needs to
> include the three letter day-of-week?

If we are going to change it, I'd be inclined to make it output the
canonical ISO format (YYYY-MM-DD HH:MM:SS.SSSS-TZ). Or perhaps the
format should be the same as whatever the current DateStyle setting
would emit.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-07 03:51:04 Re: ACM Sigmod interview with Bruce Lindsay
Previous Message Google Mike 2005-08-07 02:59:06 Poll on your LAPP Preferences