PgSqlLoader binary mode wrong datetime values
Posted: Mon 22 Feb 2010 18:46
Hi,
I'm using PgSqlLoader to insert a bunch of data onto a table.
I wanted to user binary mode to insert data, by doing loader.Mode = PgSqlLoaderMode.Binary. However, when I do so, the wrong PgSqlTimeStamp values are written onto the database.
For instance, when using text mode the following timestamp is inserted:
2009-07-24 09:38:39.502291
And when using binary mode, it is the following absurd timestamp which is inserted:
152009-06-25 06:02:22.310949
Please comment,
Miguel
I'm using PgSqlLoader to insert a bunch of data onto a table.
I wanted to user binary mode to insert data, by doing loader.Mode = PgSqlLoaderMode.Binary. However, when I do so, the wrong PgSqlTimeStamp values are written onto the database.
For instance, when using text mode the following timestamp is inserted:
2009-07-24 09:38:39.502291
And when using binary mode, it is the following absurd timestamp which is inserted:
152009-06-25 06:02:22.310949
Please comment,
Miguel