Time zone problem.

Time zone problem.

Postby isbuy » Tue 28 Jun 2005 01:06

Hello!

The following code always returns time in GMT even though I set db time zone to Pacific/Honolulu. Is it a bug or am I doing something wrong?

Please look following code.
Thanks.


DSN = "User ID=user; Password=password; Host=my.host.com;Database=mydb;Port=5432;Pooling=true;Min Pool Size=0; Max Pool Size=100;Connection Lifetime=0"
Cn = New PgSqlConnection(DSN)
Cn.Open()
Cmd = Cn.CreateCommand
Cmd.CommandText = "select now()"
sRet =Cmd.ExecuteScalar
isbuy
 
Posts: 3
Joined: Tue 28 Jun 2005 00:59

Time zone problem.

Postby Yuri » Wed 29 Jun 2005 08:45

We reproduced your problem and fixed it. This fix will be included in the next PostgreSQLDirect .NET build. It will be available in a week.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Re: Time zone problem.

Postby isbuy » Tue 05 Jul 2005 23:21

Yuri wrote:We reproduced your problem and fixed it. This fix will be included in the next PostgreSQLDirect .NET build. It will be available in a week.

I still have the same problem after installing 2.11.
isbuy
 
Posts: 3
Joined: Tue 28 Jun 2005 00:59

Time zone problem.

Postby Yuri » Wed 06 Jul 2005 07:02

We got your request and now examines the problem. Unfortunately now we couldn't give you any information. As soon as we solve the problem, we'll let you know.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL