Date/time bug
Jaromir Svasta
I discovered a bug in MI 9.0 related to date/time field. I converted a
string field containing date/time values in a form
DD.MM.YYYY HH:MM:SS
into a date/time field. After the conversion everything is fine, except that
all times between 12 and 13 hours are converted to 00 hours, see example:
Value
06.11.2007 12:05:13.000
is interpreted as
06.11.2007 00:05:13.000
Furthermore, after manually changing 00 hours to 12, the value is not
changed after moving to another value in the browser. The only thing that
helps is to write the time value in the form HHMMSSFFF (eg. 120513000).
Strange, isn't it?
The local regional setting on my XP is H:mm:ss (24 hours format).
How to overcome this?
Jaromir Svasta
State Geological Institute of Dionyz Stur
Mlynska dolina 1
817 04 Bratislava
Slovakia
Tel. +421-2-59375326
Fax. +421-2-54771940
Peter Horsbøll Møller
I have reported this as a bug to MapInfo.
The workaround is to change your regional settings.
You shoudl select an AM/PM symbol.
If you use 24 hours, the symbol will not show anyway.
Also note that if you can't use comma (,) as decimalseparator in the time field.
You must use a point (.).
If you enter this in the time field: 12:01:01,5 MapInfo will "misread it and write nothing.
If you enter 12:01:01.5 it works.
The problem also exists if you change an existing time value, you must change the , to a .
Peter Horsbøll Møller
GIS Developer, MTM GeoInformatics
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail p...@cowi.dk
http://www.cowi.dk/gis