I have an existing database that was migrated by simple reloading from
SQLAnywhere 8 to 11.
In one table there is a strange behaviour now:
There is a column of type DATE that has a NO default.
There are NO triggers defined for this column.
In Sybase Central I click on the tab "Data" to see the current rows.
I click on "Add row" to insert a blank row.
The black row shows -- with the current date found in that DATE field!

Where does that date come from?

When I want to save the row, Sybase Central complains that: 'The row could
not be instered. Converting 'Fri Aug 15 14:13:00 CEST 2008' into timestamp
not possible.'

Why can't it convert this obisous convertiable date?

When I am doing "INSERT INTO myTable (ID, BIRTHDAY) VALUES ("ID", CURRENT
DATE) and after that "SELECT * FROM myTable", then no conversion error
occurs -- note that I MUST give the CURRENT DATE manually here since when I
do not give it, it says "the column cannot be NULL" (what is correct, since
there is NO DEFAULT defined).

So I think there are two errors:

(1) Sybase Central writes the current date while actually there shall be
NULL as the default.

(2) Sybase Central is not able to convert a correct timestamp.


Thanks!
Markus