[Koha-bugs] [Bug 7806] Don't use 0000-00-00 to signal a non-existing date

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7806

--- Comment #23 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
142 when I reduce the query to only those fields that are nullable:

SELECT Concat(col.table_name, '.', col.column_name),
       col.data_type
FROM   information_schema.columns col
       JOIN information_schema.tables tab
         ON tab.table_schema = col.table_schema
            AND tab.table_name = col.table_name
            AND tab.table_type = 'BASE TABLE'
WHERE  col.data_type IN ( 'date', 'time', 'datetime', 'year', 'timestamp' )
       AND col.is_nullable = 'YES'
       AND col.table_schema NOT IN ( 'information_schema', 'sys',
                                     'performance_schema',
                                     'mysql' )
       AND col.table_schema = 'koha_demo1'
ORDER  BY col.table_schema,
          col.table_name,
          col.ordinal_position;

-- 
You are receiving this mail because:
You are watching all bug changes.