Pitney Bowes MapInfo Professional - Manual (Page 244)

Using Date- and Time-Based Data in Maps and Queries
If you maintain time- or date/time-specific data, you may be interested in querying that information and
displaying it visually in your maps. Time and DateTime data types let you display that data thematically
and as part of a query analysis. You could use this data type for many types of projects, such as to
display crime information based on Date and Time or to post schedules based on resource availability
on a particular date. Also, you can use use the date and time data from Access, Excel, dBase, and
remote databases.
Time and DateTime data types options are made available in the lists of your Query dialog boxes.
Using Time and Time/Date Data Types
You can convert existing fields with time or time/date information into Time and Time/Date formats, so
you can use them for querying and thematic maps.
To convert your data:
1. Open the data you want to convert in MapInfo Professional.
2. Chose Table > Maintenance > Table Structure and select the table for which you want to change
the data type. The Modify Table Structure dialog box displays.
3. To change the ArrivalTime field from a character field to a Time field, click the Type drop-down
arrow and select the Time type.
4. Click OK to save your change.
Adding Time or DateTime Data Types to Existing Data
MapInfo Professional 12.5 244
Querying Your Data in MapInfo Professional