Time zone problem.

isbuy · Post by **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

Yuri · Post by **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.

isbuy · Post by **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.

Yuri · Post by **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.

Devart Forums