php-firebird icon indicating copy to clipboard operation
php-firebird copied to clipboard

ibase_fetch with IBASE_UNIXTIME flag returns negatives from TIME fields

Open mlazdans opened this issue 2 months ago • 1 comments

Does it even make sense converting TIME fields into Unix timestamp? 🤔

ibase_query("CREATE TABLE TTEST (
    ID INTEGER,
    T1 TIME DEFAULT '15:45:59',
    T2 TIMESTAMP DEFAULT '2025-11-06 15:45:59'
)");
ibase_commit();
ibase_query("INSERT INTO TTEST (ID) VALUES (1)");
dump_table_rows("TTEST", null, IBASE_UNIXTIME);

array(3) { ["ID"]=> int(1) ["T1"]=> int(-2209024235) ["T2"]=> int(1762436759) }

mlazdans avatar Nov 06 '25 15:11 mlazdans

On Windows returns -1

mlazdans avatar Nov 06 '25 20:11 mlazdans