Using Valentina Time type fields

[Ruslan Zasukhin]

On 5/14/12 5:53 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:

> I need help in formatted Valentina time field. I recently converted a SQLite
> database to valentina.  The time field in SQLite showed 1 in the morning as:
> 
> 01:00:00
> 
> But it converted to:
> 
> 00:00:00:001

Please describe how you did conversion ?


> Because Valentina times fields also show 100ths of seconds. I would like the
> converted data to show as:
> 
> 
> 
> 01:00:00
> 
> 

====== 
> Is there some way to change the internal formatting of Valentina time fields?

Only exists some pattern

> Should I just use a field type "Double" or some other number format?

no

> Or can 
> someone write the complex SQL for me that copies this "Arrival_Time" field,
> changes it to correct format and saves it back.  IF the time was 01:00:00:000
> then I could use Livecode to get rid of the extra zeros before I display it.

Yes you can do this in Livecode, but only If exists some pattern ...

Hours have go somehow to  .000
Where have go minutes


> Do you think this is a SQLite to Valentina conversion bug that should be fixed
> (for future users - too late for me)?

It is strange of course

I think in lite it was as string ...



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]