ASA 10.0.1 with Servoy 6.1 Insert Into flips TIME Values to 12:00am

[former_SQLA_member1694910]

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

[MarkCulp]

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.

[thomas_duemesnil]

Any before insert trigger on the table ?

[former_SQLA_member1694910]

Just to close this out ...

I decided to change all my DATE and TIME columns to DATETIME. Now it works

greg