0


i'm querying an hadoop cluster with DbDataReader.GetValue in c#.
the problem is that i'm getting a wrong value on timestamp.
The value in hdfs file (and when querying via hive) is 1997-03-21 01:00:00
But with DbDataReader.GetValue i'm getting 1997-03-21 00:00:00
1h offset.
Any idea what might the issue?

thanks!

user2482703
  • 151
  • 2
  • 13
  • It is a timezone issue. The database is in a different timezone than your PC. – jdweng Jan 18 '18 at 16:39
  • i don't think so... i've just noticed that it's not happening to all dates. for example 1997-02-21 00:00:00 stays as is. might be that the timestamp being truncated? – user2482703 Jan 21 '18 at 08:20

0 Answers0