Wt

I was wondering why the WDate's in my Sqlite table show empty values for all dates prior to year 1970.

I think the situation is in WtSqlTraits.h here, followed in Sqlite3.C:

inline void sql_value_traits<WDate, void>
::bind(const WDate& v, SqlStatement *statement, int column, int /* size */)
{
  if (v.isNull())
    statement->bindNull(column);
  else
    statement->bind(column, v.toTimePoint() , SqlDateTimeType::Date);
}

The WDate is represented as a std::chrono::time_point using v.toTimePoint() and that refers to the distance to epoch (= 01.01.1970 00:00:00). This leads to negative values for all years prior to 1970 and an empty SQL representation - at least in my configuration: SQLite, Wt 4.9.1 built on Windows 10 using Clang64 in C++17 mode.

Is this expected behavior or a bug? :-) This way, Wt is not able to SQL-save birth dates for all persons born before 1970 :-)

Thanks,
Stefan