"Daniel Verite" writes:
> I think it would valuable to have at least a default format that
> doesn't include the sub-second precision, since it typically adds 7
> characters that enlarge output columns in a way that is generally
> useless to the human eyes. Do other users agree with that?
If y
Peter Eisentraut wrote:
On Thursday 05 March 2009 00:19:02 Daniel Verite wrote:
> SET DATESTYLE takes predefined keywords such as ISO or US as
arguments,
> but I can't find a way to specify a custom format string for
> timestamps.
There is no support for that.
> What I'd like to fin
On Thursday 05 March 2009 00:19:02 Daniel Verite wrote:
> SET DATESTYLE takes predefined keywords such as ISO or US as arguments,
> but I can't find a way to specify a custom format string for
> timestamps.
There is no support for that.
> What I'd like to find is an equivalent to Oracle's
> ALTER
Hi,
SET DATESTYLE takes predefined keywords such as ISO or US as arguments,
but I can't find a way to specify a custom format string for
timestamps.
What I'd like to find is an equivalent to Oracle's
ALTER SESSION SET nls_date_format='DD/MM/ HH24' for example,
where the format follows th
On Tue, Jul 19, 2005 at 11:51:55 -0400,
Amir Tahvildaran <[EMAIL PROTECTED]> wrote:
> Is it possible to add a custom datestyle?
>
> I am migrating from sybase to postgres and the datetime/timestamp
> formats are different, some of the existing code depends on that
> format. I thought the easi
Is it possible to add a custom datestyle?
I am migrating from sybase to postgres and the datetime/timestamp
formats are different, some of the existing code depends on that
format. I thought the easiest way would be to use a custom datestyle,
but I couldn't find out how to add one (if thats p
