Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

Gregory%20Durniak's gravatar image

Gregory Durniak
accept rate: 0%

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.

(21 Apr '13, 22:40) Mark Culp

Any before insert trigger on the table ?

(22 Apr '13, 08:06) Thomas Dueme...

Just to close this out ...

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


permanent link

answered 07 May '13, 07:42

Gregory%20Durniak's gravatar image

Gregory Durniak
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 21 Apr '13, 13:38

question was seen: 2,529 times

last updated: 07 May '13, 07:42