[Pytables-users] ReadWhere() with a Time64Col in the condition

[Julio T. <jul...@gm...>]

Hi,

I am using a Time64Col called "timestamp" in a condition, and I noticed
that the condition does not work (i.e., no rows are selected) if I write
something as:

for row in node.where("timestamp == %f" % t):
    ...

However, I had this idea of dividing the values by, say 1000, and it does
work:

for row in node.where("timestamp/1000 == %f" % t/1000):
    ...

However, this doesn't seem to be an elegant solution. Please could someone
point out a better solution to this?

Could this be related to the fact that my column name is "timestamp"? I ask
this because I use a program called HDFView to brose the HDF5 file. This
program refuses to show the first column when it is called "timestamp", but
shows it when it is called "id". I don't know if the facts are related or
not.

I don't know if this is useful information, but the conversion of a typical
"t" to string gives something like this:

>> print "%f" % t
1365597435.000000