Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

Thank you Very Much Steve. On Thu, Jun 3, 2010 at 6:10 AM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On 06/02/2010 03:29 PM, raghavendra t wrote: > >> ... >> >> Suppose am at the server-end, how could i get the client-time. Its really >> troublesome when compared with the timezone

Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

On 06/02/2010 03:29 PM, raghavendra t wrote: ... Suppose am at the server-end, how could i get the client-time. Its really troublesome when compared with the timezone column in a table. Not sure what you are getting at. You are always connected to the server _through_ a client and you _tell_

Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

Hi All, Thank you for the update. Suppose am at the server-end, how could i get the client-time. Its really troublesome when compared with the timezone column in a table. Regards Raghavendra On Wed, Jun 2, 2010 at 11:37 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On 06/02/201

Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

On 06/02/2010 02:48 AM, raghavendra t wrote: Hi All, How do i get the client time and server time. I am connecting remotely. If i give SELECT CURRENT_TIME;,it shows the server time. How do we get the client time ? Time is the same everywhere but displayed in different ways according to loca

Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

On Wednesday 02 June 2010 13.46:47 Stephen Frost wrote: > * raghavendra t (raagavendra@gmail.com) wrote: > > How do i get the client time and server time. I am connecting remotely. > > If i give SELECT CURRENT_TIME;,it shows the server time. How do we get > > the client time ? > > uh, \! date

Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

* raghavendra t (raagavendra@gmail.com) wrote: > How do i get the client time and server time. I am connecting remotely. If i > give SELECT CURRENT_TIME;,it shows the server time. How do we get the client > time ? uh, \! date ? Stephen signature.asc Description: Digital signature

Re: [GENERAL] How do we get the Client-Time and Server-Time from psql ?

On 02/06/2010 10:48, raghavendra t wrote: > Hi All, > > How do i get the client time and server time. I am connecting > remotely. If i give SELECT CURRENT_TIME;,it shows the server time. > How do we get the client time ? I don't think you can, from within a query anyway - it's always going to run

[GENERAL] How do we get the Client-Time and Server-Time from psql ?

Hi All, How do i get the client time and server time. I am connecting remotely. If i give SELECT CURRENT_TIME;,it shows the server time. How do we get the client time ? Thanks in Advance Regards Raghavendra