Re: [SQL] postgres time zone settings(time difference in Server and client)

Hai all, my postgres version is PostgreSQL 8.1.8 didn't support clock_timestamp() regards: Anoop

Re: [SQL] postgres time zone settings(time difference in Server and client)

2008/7/25 Anoop G <[EMAIL PROTECTED]>: > > Hai all, > >I have database running on server. I am using python to run my > application.postgres client is running on the clients .All clients are > connected to a single database running on server. Each time application > starts ,the login time is

Re: [SQL] postgres time zone settings(time difference in Server and client)

Anoop G wrote: Hai all, I have database running on server. I am using python to run my application.postgres client is running on the clients .All clients are connected to a single database running on server. Each time application starts ,the login time is taken from server using the query "

Re: [SQL] postgres time zone settings(time difference in Server and client)

Hai all, I have database running on server. I am using python to run my application.postgres client is running on the clients .All clients are connected to a single database running on server. Each time application starts ,the login time is taken from server using the query """select CAST ( t

Re: [SQL] postgres time zone settings

On Thu, Jul 24, 2008 at 7:56 AM, Anoop G <[EMAIL PROTECTED]> wrote: > Hai all, > > when i was going through the Postgresql documents, i came across a section > which tells about the TIME ZONE settings > > > what i understood from the document is, based on the value given in this > conf file postgre