Subject save and retrive datetime data type
Author
Hi,

I'm working with fdb 1.8 and firebird 2.5. I get any behavior that confuse me, maybe I'm misunderstanding something.

I have a datetime python object with microsecond precisions on it. Inserting this into a table and when retrive the inserted record I lost the microsecond precision (firebird works with milliseconds, right?)

Example:

>> d = datetime.datetime(2015, 6, 15, 14, 30, 50, 321)
>>> d.microsecond
321

>> sql = "INSERT INTO DB_FUNCTIONS_DTMODEL (ID, NAME, START_DATETIME) VALUES (?, ?, ?)"

Where START_DATETIME is TIMESTAMP field.

>> cur.execute(s, (None, 'test4', d))

>> cur.execute("SELECT r.ID, r.NAME, r.START_DATETIME FROM DB_FUNCTIONS_DTMODEL r")
>> r = cur.fetchone()
>> r
(320, 'test1', datetime.datetime(2015, 6, 15, 14, 30, 50, 300))

>>> r[2].microsecond
300

The original microsecond was 321.

So, I need explicit datatype conversion or work datetime as string wirh microsecond to millisecond replacement?
Is a bug?
Is a feature?


Regards
Maxi