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
