Re: libpg date/timestamps format used by PQgetvalue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Ayers <d(dot)ayers(at)inode(dot)at>
Cc: pgsql-novice(at)postgresql(dot)org, Matt Rice <ratmice(at)yahoo(dot)com>
Subject: Re: libpg date/timestamps format used by PQgetvalue
Date: 2004-04-28 04:55:05
Message-ID: 23287.1083128105@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

David Ayers <d(dot)ayers(at)inode(dot)at> writes:
> It's been reported that on some systems
> we get something like:
> %d/%m/%Y %H:%M:%S.00 %Z
> and others:
> %m-%d-%Y %H:%M:%S %Z

> Is this version/local dependent?

No, but it is dependent on the DateStyle configuration variable ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-04-28 05:00:07 Re: Could not create shared memory segment...(in linux)
Previous Message Tom Lane 2004-04-28 04:51:42 Re: Running postgresql on localhost