Dear All,
MapInfo has no concept of time. We came over a similar problem when wanting
to store time information (of criminal offences) using an ODBC link with
Access (MI v5.0 and Access 97).
We got over the problem by storing the time in text format and as a twenty
four hour clock. By storing the time data in text format the alpha-numerics
of the text are recognised and time based queries can be carried out. For
example, the time 9.30 in the morning is stored as '9:30' (MI text format),
and the time 8.45 in the evening is stored as '20:45' (MI text format).
Using this format, you can then succesfully carry out any time based SQL
operation (eg select all records where time is greater than 9:30 but less
than 20:45).
Similarly, store the time information in text format in Access. Any time
data you then bring into MI will also be formated as text, and operations as
above can be carried out with success.
Good luck.
Regards,
Spencer Chainey
Corporate GIS Manager
London Borough of Hackney
[EMAIL PROTECTED]
-----Original Message-----
From: Hugh Staughton <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 13 March 1999 17:21
Subject: Getting a "Time" field type into MI
>Hello,
>
> I am new to MapInfo and MapBasic. I need to get a table from Access
>into MapInfo. The problem is that the Access table has a Date/Time
>column that contains Time values (ie 9:35:00) but MapInfo doesn't seem
>to support this feature and converts all of the times to dates (ie
>9:35:00 becomes 01/30/98 and so on).
>
> Does anybody know how to rectify this problem? It seems that ODBC
>and import both fail on this problem.
>
>Thanks
>
>Hugh Staughton
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
