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

gdurniak's gravatar image

gdurniak
1222
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

greg

permanent link

answered 07 May '13, 07:42

gdurniak's gravatar image

gdurniak
1222
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×28
×3

question asked: 21 Apr '13, 13:38

question was seen: 683 times

last updated: 07 May '13, 07:42