php-firebird
php-firebird copied to clipboard
ibase_fetch with IBASE_UNIXTIME flag returns negatives from TIME fields
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) }
On Windows returns -1