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 asked 21 Apr '13, 13:38 Gregory Durniak |
Just to close this out ... I decided to change all my DATE and TIME columns to DATETIME. Now it works greg answered 07 May '13, 07:42 Gregory Durniak |
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 ?