SCM

[#1000652] Time problem

View Trackers | Bugs | Download .csv | Monitor

Date:
2006-05-26 08:49
Priority:
3
State:
Open
Submitted by:
Ciril Santos (cirix81)
Assigned to:
Nobody (None)
Npgsql Version:
None
Category:
Group:
Resolution:
None
Summary:
Time problem

Detailed description
I have o postgresql server installed in a gentoo linux OS.
When i lauch "Select current_timestamp" in pgadmin3, the result is right, but when a use the same command in Npgsql the time is wrong (+1 hour). The timezone of postgresql is Europe/Lisbon and my timezone in the client computer is the same.

The server is 8.1.3

Followup

Message
Date: 2006-09-02 12:24
Sender: Nobody

Hey, you were right! it was indeed a "time" column.. My mistake..
Date: 2006-08-22 18:09
Sender: Francisco Figueiredo jr.


Hi, about this infinity problem, it seems your datatype in your database is time, not timestamp. From your error message:

invalid input syntax for type *time*:

Can you check that?

Thanks in advance.


About timezone, I'm still checking it, Ciril. Sorry for taking so long.
Date: 2006-08-22 15:11
Sender: Ciril Santos

Hi, thanks for the response but my problem was the OS not
postgresql. Sorry
Date: 2006-08-20 17:30
Sender: Nobody

A time related problem is when I try to store a Datetime.MinValue object in a timestamp column. I get a Npgsql.NpgsqlException: ERROR: 22007: invalid input syntax for type time: "-infinity"
Date: 2006-07-28 18:35
Sender: Francisco Figueiredo jr.


Hi Ciril.

Can you give some test sample? I know Npgsql gets the data the way postgresql presents to him. Maybe pgadmin is setting something about timezone which makes postgresql present it a datetime with timezone fixed. I will check that.

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge