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