[GENERAL] Problem with timestamp

2007-05-29 Thread Mageshwaran
Hi, We have our application which uses postgres 7.1.3 version in that we use a time functions like now(),timestamp. etc mostly timestamp without timezone.We don't need the timezone in that variable so we ignore it using timestamp without timezone. The same is not working with high

Re: [GENERAL] Problem with Timestamp

2006-01-18 Thread vishal saberwal
hi, though i dont use JDBC, i was just interested and found some links (which may be helpful) ... http://archives.postgresql.org/pgsql-bugs/2004-02/msg00028.php http://72.14.203.104/search?q=cache:ptQFfXTM0pgJ:snaga.org/pgsql/cvsweb.cgi/pgsql/src/interfaces/jdbc/org/postgresql/test/jdbc2/Timesta

[GENERAL] Problem with Timestamp

2006-01-18 Thread boff
Hi.. I'm having some problems with Timestamp.   I have a TIMESTAMP WITH TIME ZONE field called 'time' in my table. The value of this field will be given by the "java.sql.Timestamp" in my application. When I store this value in the table it's correct, but when I make a SELECT in this field and take