Devart Forums

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

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 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.

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.