When using the Convert Temporal Field tool, the list of standard supported input time formats varies depending on whether the input time values are stored in a string or numeric (short, long, float, or double) field.For example, when using the Convert Time Field tool to convert a time value of Tuesday, August 20, 2002, stored as a string into a date format, specify the input time format as dddd, MMMM dd, yyyy. However, if you have time values stored in a string field using a custom date and time format, you can create a custom date and time format to interpret your data. Standard formats are supported with the Convert Temporal Field tool. Use this tool to specify a standard or custom time format for interpreting date and time values and converting those into one of the date formats. If you have time values stored in a string or numeric (short, long, float, or double) field, you can convert them into a date field type using the Convert Temporal Field geoprocessing tool. Learn more about best practices for storing temporal data They are moreĮfficient for query performance and support more sophisticatedĭatabase queries than storing time in a numeric or string Specifically designed for storing time and date information. It is recommended that you store the time values of your temporalĭata in one of the dedicated date field types.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |