I'm having trouble with a TIME column. The front end application is Servoy 6.1
When a Time is entered into an existing record, it is saved correctly
But when a record is duplicated, with an INSERT INTO, any TIME value is saved as 12:00am
I turned on tracing, and see that the INSERT does have the correct TIME Value e.g. '1970-01-01 20:00:00.000'
and if I INSERT INTO by hand using dbisql, it also works
how could this be ? there are no auto enter or calculated values. Very strange ...
asked 21 Apr '13, 13:38
Just to close this out ...
I decided to change all my DATE and TIME columns to DATETIME. Now it works
answered 07 May '13, 07:42