Database Date and Time Fields
Submenu on "EDIT" button on
database
table form. The button is only enabled if you check the box on the
right of the row of buttons, since all changes are permanent (save a copy of the
database if you are concerned about editing mistakes).
- Insert time animation fields (for
KML/KMZ file). Insure that you have the fields you need before
proceeding.
- Insert date field: if fields MONTH, DAY, YEAR exist, they will be
concatenated into a string field of the form "12/25/1944".
There will not be any padding for single digit months and days.
- Insert Year/month/day
- Insert Julian date (annual)
- Split date field (MM//DD/YYYY): takes date in the form MM/DD/YY, and creates
fields YEAR, MONTH, and DAY. The date does not require leading
zeroes for month and day. If the year only has two digits, for values
less than 20 it assumes the 21st century, and for 21 to 99 it assumes the
20th century.
- Split date field (YYYYMMDD): creates fields YEAR, MONTH, and DAY.
Month and day must have two digits each.
- Format date field: must have a DATE_LABEL field
- MM/DD/YYYY
- M/D/YYYY
- YYYY/MM/DD: in this format, dates will be in alphabetical order.
- Split time string (HH:MM:SS): creates fields "HOUR",
'MINUTE", and "SECOND".
- Time field (HHMMSS or HH:MM:SS) to dec hours: creates a DEC_HOURS field
which will have decimal hours.
- Time fields (Hour/Minute/Second) to dec hours: creates an
DEC_HOURS field which will have decimal hours, from fields "HOUR", 'MINUTE",
and "DAY".
- Time fields (Day/Hour/Minute/Second) to dec days: creates an
DEC_DAYS field which will have decimal hours, from fields "DAY","HOUR",
'MINUTE", and "SECOND".
- Time fields to dec Julian days (annual)
- Time fields to dec years
- Dec hours to HH:MM:SS--Uses DEC_HOURS to create a TIME_STR field
(such as needed for KML time animations); hours, minutes, and seconds will
have leading zeros so each is two digits.
- Military time to HH:MM:SS
- Day of week from Year/Month/Day: if fields MONTH, DAY, YEAR
exist, this will compute the day of the week.
- Days since full moon: if fields MONTH, DAY, YEAR
exist, this will compute the number of days since the last full moon.
Currently it only gives answers to an even number of days.
- Format date field
Time fields used by MICRODEM database operations:
| Name |
Type |
Example |
Notes |
| HOUR |
Integer |
|
|
| MINUTE |
Integer |
|
|
| SECOND |
Integer |
|
|
| DAY |
Integer |
|
|
| MONTH |
Integer |
|
|
| YEAR |
Integer |
|
|
| DEC_HOURS |
Float |
|
|
| DEC_DAYS |
Float |
|
|
| TIME_STR |
String |
HH:MM:SS |
|
| START_DATE |
String |
1999-12-31T23:59:59Z (UTC) |
Used for KML/KMZ |
| END_DATE |
String |
|
|
| DATE |
String |
MM/DD/YY |
If the year only has two digits, for values less than 20 it assumes
the 21st century, and for 21 to 99 it assumes the 20th century.
The date does not require leading zeroes for month and day. |
| DATE_LABEL |
String |
MM/DD/YYYY |
|
Last revision 2/16/2016