Skip site navigation (1) Skip section navigation (2)

libpg date/timestamps format used by PQgetvalue

From: David Ayers <d(dot)ayers(at)inode(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Cc: Matt Rice <ratmice(at)yahoo(dot)com>
Subject: libpg date/timestamps format used by PQgetvalue
Date: 2004-04-23 11:48:53
Message-ID: 408902A5.6020008@inode.at (view raw or flat)
Thread:
Lists: pgsql-novice
Hello everyone,

I've been unsuccessful in finding the place in the documentation which 
describes how to determine the format of dates and timestamps in the 
string returned by PQgetvalue.  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?  Or better yet, is there an API in 
which we can query about the format or even set it?

I'd like to avoid wrapping all date and timestamp attributes in 
to_char() if possible.

Thanks for any advice or pointers.

Cheers,
David

PS: I'm not subscribed.


Responses

pgsql-novice by date

Next:From: Derrick BettsDate: 2004-04-23 18:39:24
Subject: Transaction speed
Previous:From: Joe ConwayDate: 2004-04-22 21:22:31
Subject: Re: How do I trigger the re-creation of a crosstab-type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group