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 ... greg |
Just to close this out ... I decided to change all my DATE and TIME columns to DATETIME. Now it works greg |
I think it might help to show us some code. I.e. show us exactly what you are doing so we can help you figure out what is happening.
Any before insert trigger on the table ?