Name: GISOWNER.NewDateTypes_table
Display Field: id
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- id (type: esriFieldTypeInteger, alias: id, SQL Type: sqlTypeOther, nullable: true, editable: true)
- latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- date_notime (type: esriFieldTypeDate, alias: date_notime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_000000 (type: esriFieldTypeDate, alias: date_000000, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_000001 (type: esriFieldTypeDate, alias: date_000001, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_040000 (type: esriFieldTypeDate, alias: date_040000, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_114530 (type: esriFieldTypeDate, alias: date_114530, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_200000 (type: esriFieldTypeDate, alias: date_200000, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- date_235959 (type: esriFieldTypeDate, alias: date_235959, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- str_yyyy (type: esriFieldTypeInteger, alias: str_yyyy, SQL Type: sqlTypeOther, nullable: true, editable: true)
- str_yyyy_mm (type: esriFieldTypeString, alias: str_yyyy-MM, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- str_yyyy_mm_dd (type: esriFieldTypeDate, alias: str_yyyy-MM-dd, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- str1_yyyy_mm_dd_hh_mm_ss (type: esriFieldTypeDate, alias: str1_yyyy-MM-dd_HH-mm-ss, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- str2_yyyy_mm_dd_hh_mm_ss (type: esriFieldTypeDate, alias: str2_yyyy-MM-dd_HH-mm-ss, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- str_yyyy_mm_dd_hh_mm_ss_s (type: esriFieldTypeString, alias: str_yyyy-MM-dd_HH-mm-ss-S, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- int_yyyy (type: esriFieldTypeInteger, alias: int_yyyy, SQL Type: sqlTypeOther, nullable: true, editable: true)
- int_yyyymm (type: esriFieldTypeInteger, alias: int_yyyyMM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- int_yyyymmdd (type: esriFieldTypeInteger, alias: int_yyyyMMdd, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dbl1_yyyymmddhhmmss (type: esriFieldTypeDouble, alias: dbl1_yyyyMMddHHmmss, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dbl2_yyyymmddhhmmss (type: esriFieldTypeDouble, alias: dbl2_yyyyMMddHHmmss, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dbl_yyyymmddhhmmsss (type: esriFieldTypeDouble, alias: dbl_yyyyMMddHHmmssS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- day (type: esriFieldTypeInteger, alias: day, SQL Type: sqlTypeOther, nullable: true, editable: true)
- month (type: esriFieldTypeInteger, alias: month, SQL Type: sqlTypeOther, nullable: true, editable: true)
- month_str_1 (type: esriFieldTypeString, alias: month_str_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- year (type: esriFieldTypeInteger, alias: year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- weekday_str (type: esriFieldTypeString, alias: weekday_str, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- week_number (type: esriFieldTypeInteger, alias: week_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- day365 (type: esriFieldTypeInteger, alias: day365, SQL Type: sqlTypeOther, nullable: true, editable: true)
- isfeb29 (type: esriFieldTypeInteger, alias: isfeb29, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dst (type: esriFieldTypeInteger, alias: DST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dst_switch (type: esriFieldTypeInteger, alias: DST_switch, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dst_adjust (type: esriFieldTypeInteger, alias: DST_adjust, SQL Type: sqlTypeOther, nullable: true, editable: true)
- str_yyyy_new (type: esriFieldTypeString, alias: str_yyyy_new, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- str_yyyy_mm_dd_new (type: esriFieldTypeString, alias: str_yyyy_MM_dd_new, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- str1_yyyy_mm_dd_hh_mm_ss_new (type: esriFieldTypeString, alias: str1_yyyy_MM_dd_HH_mm_ss_new, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- str2_yyyy_mm_dd_hh_mm_ss_new (type: esriFieldTypeString, alias: str2_yyyy_MM_dd_HH_mm_ss_new, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- yyyy_mm_dd_dateonly (type: esriFieldTypeDateOnly, alias: yyyy_MM_dd_dateOnly, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TimeOnly (type: esriFieldTypeTimeOnly, alias: TimeOnly, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: GISOWNER.NewDateTypes_table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 6/23/2025 4:59:26 PM
Schema Last Edit Date: 6/23/2025 4:56:09 PM
Data Last Edit Date: 6/23/2025 4:59:26 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Boxplots
Add Features
Update Features
Delete Features
Apply Edits
Streaming
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat