Loading Data into Virtualitics Explore Desktop – Virtualitics

Loading your dataset is the first step to diving into your data in Virtualitics Explore Desktop. Virtualitics Explore Desktop supports various data types, and that data can be loaded from a number of locations, including remote options. If your file contains time and date data, you will also want to be familiar with the accepted time and date formats in Virtualitics Explore Desktop.

Supported File Types

Virtualitics Explore Desktop supports import of the following:

CSV	A Comma Separated Values file
Excel (.xls, .xlsx)	For workbooks with multiple worksheets, you can select a specific worksheet from the ‘Worksheets’ dropdown in the Dataset Preview window
Text file (.txt)	Must specify the delimiter used to separate values in the Dataset Preview window
JSON file	Specific file type for loading in network data (see Network Data Formats)
OBJ file	Standard 3D image format which includes 3D coordinates, texture maps, polygonal faces, and other object information
VIP Project	A previously saved Virtualitics Explore Desktop project with a “.vip” extension

To Load Data into Virtualitics Explore Desktop:

At the top of the left-side navigation bar, locate the Files section.
Beneath Files, choose Local or Remote:

Local	Load a local dataset file or a previously saved Virtualitics Explore project file (.vip).
Remote	Load from a remote database. Options include: Databricks Snowflake SQL database URL MySQL Redshift Postgres Hadoop (Hive) Hadoop (Impala) BigQuery Any data source with an Open Database Connectivity (OBDC) driver.

Tip: You can also load local files or .vip project files by clicking File in the top menu bar and choosing Load Dataset or Load Project.

Once you've confirmed and selected your file, the Dataset Preview window will appear. Dataset Preview enables you to set specific view options and validate that the data is properly parsed before loading.
Click the Load Dataset button. This will load your file into Virtualitics Explore Desktop and automatically open your data in Spreadsheet View, which allows you to view the entire dataset as a table and see distributions for each column.

Video Tutorial

Accepted Time and Date Formats

Virtualitics Explore Desktop recognizes columns as Datetime column types when they have the following formats.

Important: If any cell in the column does not match one of these formats, the software will not recognize the column as a Datetime column.

Note: If you typically use a different format not included here, please contact us at support@virtualitics.com with a sample of the format so that we can add it into our next release.

Related Article: Preprocessing Your Data (Reformatting Datetime Values)

Time Only

"HH:mm:ss tt",
"hh:mm:ss tt",
"HH:mm tt",
"hh:mm tt",
"HH:mm:ss",
"hh:mm:ss",
"H:mm:ss",
“h:mm:ss",
"h:mm tt”,
"h:mm tt",

Day-First Formats (no time)

"dd MMM yyyy",
“dd-MMM-yyyy",
“dd-MMM-yy”,
"dd MMM yy",
“dd/MMM/yyyy”,
“dd/MMM/yy",
“dd/MM/yyyy",
“dd/MM/yy”,
“dd/M/yyyy”,
“dd/M/yy",
“d-MMM-yyyy”,
"d MMM yyyy”,
“d-MMM-yy",
"d MMM yy”,
“d/MM/yyyy”,
“d/MM/yy",
"d/M/yyyy",
"d/M/yy",

Day-First Formats (with time)

"dd/MM/yyyy HH:mm:ss tt zzz”,
"dd/MM/yyyy HH:mm:ss tt",
"dd/MM/yyyy HH:mm:ss",
"dd/MM/yyyy hh:mm:ss tt zzz",
"dd/MM/yyyy hh:mm:ss tt",
"dd/MM/yyyy hh:mm:ss”,
"dd/MM/yyyy hh:mm”,
"dd/MM/yyyy hh:mm”,
"dd/MM/yyyy h:mm:ss tt zzz”,
"dd/MM/yyyy h:mm:ss tt",
"dd/MM/yyyy h:mm:ss”,
"dd/MM/yyyy HH:mm”,
"dd/MM/yyyy HH:mm",
"dd/MM/yyyy h:mm”,
"dd/MM/yy HH:mm:ss tt zzz",
"dd/MM/yy HH:mm:ss tt",
"dd/MM/yy HH:mm:ss",
"dd/MM/yy HH:mm”,
"dd/MM/yy HH:mm",
"dd/MM/yy hh:mm:ss tt zzz",
"dd/MM/yy hh:mm:ss tt",
"dd/MM/yy hh:mm:ss",
"dd/MM/yy hh:mm”,
"dd/MM/yy hh:mm",
"dd/MM/yy h:mm:ss tt zzz",
"dd/MM/yy h:mm:ss tt",
"dd/MM/yy h:mm:ss",
"dd/MM/yy h:mm”,
"dd/M/yyyy HH:mm”,
"dd/M/yy HH:mm”,
"dd/M/yy hh:mm",
"d/MM/yyyy HH:mm”,
"d/MM/yy HH:mm",
"d/MM/yyyy hh:mm”,
"dd/M/yyyy hh:mm",
"d/M/yyyy HH:mm",
"d/M/yyyy HH:mm:ss tt",
"d/M/yyyy H:mm:ss tt”,
"d/MM/yy hh:mm",
"d/M/yyyy h:mm",
"d/M/yyyy h:mm:ss tt",
"d/M/yyyy hh:mm",
"d/M/yyyy hh:mm:ss tt",
"d/M/yy HH:mm:ss tt",
"d/M/yy H:mm:ss tt",
"d/M/yy HH:mm”,
"d/M/yy hh:mm",
"d/M/yy hh:mm:ss tt”,
"d/M/yy h:mm:ss tt",
"d/M/yy h:mm",

Month-First Formats (no time)

"M/d/yyyy",
"M/dd/yyyy",
"MM/d/yyyy",
“MM/dd/yyyy",
"M/d/yy",
"MM/d/yy",
"M/dd/yy",
“MM/dd/yy”,
“M-d-yyyy",
"M/d/yy",
"M/dd/yy",
"MM/d/yy",
“MM/dd/yy”,
“MM-dd-yy",
“M-d-yy",
"M-yyyy",
"M-d-yyyy",
"M-dd-yyyy",
"M-ddd-yyyy",
"M-dddd-yyyy",
"M/yyyy",
"M/d/yyyy",
"M/dd/yyyy",
"M/ddd/yyyy",
"M/dddd/yyyy",
"MM-yyyy",
"MM-d-yyyy",
"MM-dd-yyyy",
"MM-ddd-yyyy",
"MM-dddd-yyyy",
"MM/yyyy",
"MM/d/yyyy",
"MM/dd/yyyy",
"MM/ddd/yyyy",
"MM/dddd/yyyy",
"MMM-yyyy",
"MMM-d-yyyy",
"MMM-dd-yyyy",
"MMM-ddd-yyyy",
"MMM-dddd-yyyy",
"MMM/yyyy",
"MMM/d/yyyy",
"MMM/dd/yyyy",
"MMM/ddd/yyyy",
"MMM/dddd/yyyy",
"MMMM-yyyy",
"MMMM-d-yyyy",
"MMMM-dd-yyyy",
"MMMM-ddd-yyyy",
"MMMM-dddd-yyyy",
"MMMM/yyyy",
"MMMM/d/yyyy",
"MMMM/dd/yyyy",
"MMMM/ddd/yyyy",
"MMMM/dddd/yyyy",

Month-First Formats (with time)

"MM/dd/yyyy HH:mm:ss tt zzz",
"MM/dd/yyyy HH:mm:ss tt",
"MM/dd/yyyy HH:mm:ss",
"MM/dd/yyyy HH:mm",
"M/d/yyyy HH:mm",
"M/d/yyyy HH:mm:ss tt",
"M/d/yyyy H:mm:ss tt",
"M/dd/yyyy HH:mm",
"MM/d/yyyy HH:mm",
"MM/dd/yyyy HH:mm",
"MM/dd/yyyy hh:mm:ss tt zzz",
"MM/dd/yyyy hh:mm:ss tt",
"MM/dd/yyyy hh:mm:ss",
"MM/dd/yyyy hh:mm",
"MM/dd/yyyy h:mm:ss tt zzz",
"MM/dd/yyyy h:mm:ss tt",
"MM/dd/yyyy h:mm:ss",
"MM/dd/yyyy h:mm",
"M/d/yyyy h:mm",
"M/d/yyyy h:mm:ss tt",
"M/d/yyyy hh:mm",
"M/d/yyyy hh:mm:ss tt",
"M/dd/yyyy hh:mm",
"MM/d/yyyy hh:mm”,
"MM/dd/yyyy hh:mm”,
"M/d/yyyy H:mm",
"MM-dd-yyyy",
"MM-dd-yyyy HH:mm:ss tt zzz",
"MM-dd-yyyy HH:mm:ss tt",
"MM-dd-yyyy HH:mm:ss",
"MM-dd-yyyy HH:mm",
"MM-dd-yyyy HH:mm",
"MM-dd-yyyy HH:mm:ss tt",
"MM-dd-yyyy H:mm:ss tt",
"MM-dd-yyyy HH:mm",
"MM-dd-yyyy HH:mm",
"MM-dd-yyyy HH:mm",
"MM-dd-yyyy hh:mm:ss tt zzz",
"MM-dd-yyyy hh:mm:ss tt",
"MM-dd-yyyy hh:mm:ss",
"MM-dd-yyyy hh:mm",
"MM-dd-yyyy h:mm:ss tt zzz",
"MM-dd-yyyy h:mm:ss tt",
"MM-dd-yyyy h:mm:ss",
"MM-dd-yyyy h:mm",
"MM-dd-yyyy h:mm",
"MM-dd-yyyy h:mm:ss tt",
"MM-dd-yyyy hh:mm",
"MM-dd-yyyy hh:mm:ss tt",
"MM-dd-yyyy hh:mm",
"MM-dd-yyyy hh:mm",
"MM-dd-yyyy hh:mm”,
"M-d-yyyy HH:mm:ss tt zzz",
"M-d-yyyy HH:mm:ss tt",
"M-d-yyyy HH:mm:ss",
"M-d-yyyy HH:mm",
"M-d-yyyy HH:mm",
"M-d-yyyy HH:mm:ss tt",
"M-d-yyyy H:mm:ss tt",
"M-d-yyyy HH:mm",
"M-d-yyyy HH:mm",
"M-d-yyyy HH:mm",
"M-d-yyyy hh:mm:ss tt zzz",
"M-d-yyyy hh:mm:ss tt",
"M-d-yyyy hh:mm:ss",
"M-d-yyyy hh:mm",
"M-d-yyyy h:mm:ss tt zzz",
"M-d-yyyy h:mm:ss tt",
"M-d-yyyy h:mm:ss",
"M-d-yyyy h:mm",
"M-d-yyyy h:mm",
"M-d-yyyy h:mm:ss tt",
"M-d-yyyy hh:mm",
"M-d-yyyy hh:mm:ss tt",
"M-d-yyyy hh:mm",
"M-d-yyyy hh:mm",
"M-d-yyyy hh:mm",
"MM/dd/yy HH:mm:ss tt zzz",
"MM/dd/yy HH:mm:ss tt",
"MM/dd/yy HH:mm:ss",
"MM/dd/yy HH:mm",
"M/d/yy HH:mm",
"M/d/yy HH:mm:ss tt",
"M/d/yy H:mm:ss tt",
"M/dd/yy HH:mm",
"MM/d/yy HH:mm",
"MM/dd/yy HH:mm",
"MM/dd/yy hh:mm:ss tt zzz",
"MM/dd/yy hh:mm:ss tt",
"MM/dd/yy hh:mm:ss",
"MM/dd/yy hh:mm",
"MM/dd/yyyh:mm:ss tt zzz",
"MM/dd/yyyh:mm:ss tt",
"MM/dd/yy h:mm:ss",
"MM/dd/yy h:mm",
"M/d/yy h:mm",
"M/d/yy h:mm:ss tt",
"M/d/yy hh:mm",
"M/d/yy hh:mm:ss tt",
"M/dd/yy hh:mm",
"MM/d/yy hh:mm",
"MM/dd/yy hh:mm”,
"MM-dd-yy HH:mm:ss tt zzz",
"MM-dd-yy HH:mm:ss tt",
"MM-dd-yy HH:mm:ss",
"MM-dd-yy HH:mm",
"MM-dd-yy HH:mm",
"MM-dd-yy HH:mm:ss tt",
"MM-dd-yy H:mm:ss tt",
"MM-dd-yy HH:mm",
"MM-dd-yy HH:mm",
"MM-dd-yy HH:mm",
"MM-dd-yy hh:mm:ss tt zzz",
"MM-dd-yy hh:mm:ss tt",
"MM-dd-yy hh:mm:ss",
"MM-dd-yy hh:mm",
"MM-dd-yy h:mm:ss tt zzz",
"MM-dd-yy h:mm:ss tt",
"MM-dd-yy h:mm:ss",
"MM-dd-yy h:mm",
"MM-dd-yy h:mm",
"MM-dd-yy h:mm:ss tt",
"MM-dd-yy hh:mm",
"MM-dd-yy hh:mm:ss tt",
"MM-dd-yy hh:mm",
"MM-dd-yy hh:mm",
"MM-dd-yy hh:mm”,
"M-d-yy HH:mm:ss tt zzz",
"M-d-yy HH:mm:ss tt",
"M-d-yy HH:mm:ss",
"M-d-yy HH:mm",
"M-d-yy HH:mm",
"M-d-yy HH:mm:ss tt",
"M-d-yy H:mm:ss tt",
"M-d-yy HH:mm",
"M-d-yy HH:mm",
"M-d-yy HH:mm",
"M-d-yy hh:mm:ss tt zzz",
"M-d-yy hh:mm:ss tt",
"M-d-yy hh:mm:ss",
"M-d-yy hh:mm",
"M-d-yy h:mm:ss tt zzz",
"M-d-yy h:mm:ss tt",
"M-d-yy h:mm:ss",
"M-d-yy h:mm",
"M-d-yy h:mm",
"M-d-yy h:mm:ss tt",
"M-d-yy hh:mm",
"M-d-yy hh:mm:ss tt",
"M-d-yy hh:mm",
"M-d-yy hh:mm",
"M-d-yy hh:mm",

Year-First Formats (no time)

"yyyy MMM dd",
“yyyy-MMM-dd",
“yyyy/MM/dd",
“yyyy/MMM/dd",
“yyyy-MM-dd",
"yyyy/dd/MM",
“yyyy/dd/MMM",
“yyyy-dd-MM”,
"yy/MMM/dd",
“yy/MM/dd",
“yy-MM-dd”,
“yy/dd/MMM",
"yy/dd/MM",
“yy-dd-MM",

Year-First Formats (with time)

"yyyy/MM/dd HH:mm",
"yyyy/MM/dd hh:mm”,
"yyyy/dd/MM HH:mm",
"yyyy/dd/MM hh:mm”,
"yy/dd/MM HH:mm",
"yy/dd/MM hh:mm",
"yyyy-MM-dd HH:mm:ss",
"yyyy-MM-dd hh:mm:ss",
"yyyy-MM-dd HH:mm:ss.f",
"yyyy-MM-dd hh:mm:ss.f",
"yyyy-MM-dd HH:mm:ss.ff",
"yyyy-MM-dd hh:mm:ss.ff",
"yyyy-MM-dd HH:mm:ss.fff",
"yyyy-MM-dd hh:mm:ss.fff",
"yyyy-MM-dd hh:mm:ss tt",
"yyyy-MM-dd hh:mm:ss tt zzz",
"yyyy-MM-dd'T'HH:mm",
"yyyy-MM-dd'T'hh:mm",
"yyyy-MM-dd'T'HH:mm:ss.fff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.fff'Z'",
"yyyy-MM-dd'T'HH:mm:ss.fff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.fff'Z'",
"yyyy-MM-dd'T'HH:mm:ss.ffff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.ffff'Z'",
"yyyy-MM-dd'T'HH:mm:ss.fffff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.fffff'Z'",
"yyyy-MM-dd'T'HH:mm:ss.ffffff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.ffffff'Z'",
"yyyy-MM-dd'T'HH:mm:ss.fffffff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.fffffff'Z'",
"yyyy--dd'T'HH:mm:ss.ffffffff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.ffffffff'Z'",
"yyyy-MM-dd'T'HH:mm:ss.fffffffff'Z'",
"yyyy-MM-dd'T'hh:mm:ss.fffffffff'Z'",
"yyyy-MM-dd HH:mm:ss.fff",
"yyyy-MM-dd hh:mm:ss.fff",
"yyyy-MM-dd HH:mm:ss.ffff",
"yyyy-MM-dd hh:mm:ss.ffff",
"yyyy-MM-dd HH:mm:ss.fffff",
"yyyy-MM-dd hh:mm:ss.fffff",
"yyyy-MM-dd HH:mm:ss.ffffff",
"yyyy-MM-dd hh:mm:ss.ffffff",
"yyyy-MM-dd HH:mm:ss.fffffff",
"yyyy-MM-dd hh:mm:ss.fffffff",
"yyyy-MM-dd HH:mm:ss.ffffffff",
"yyyy-MM-dd hh:mm:ss.ffffffff",
"yyyy-MM-dd HH:mm:ss.fffffffff",
"yyyy-MM-dd hh:mm:ss.fffffffff",
"yyyy-MM-dd'T'HH:mm:ss.fff",
"yyyy-MM-dd'T'hh:mm:ss.fff",
"yyyy-MM-dd'T'HH:mm:ss.ffff",
"yyyy-MM-dd'T'hh:mm:ss.ffff",
"yyyy-MM-dd'T'HH:mm:ss.fffff",
"yyyy-MM-dd'T'hh:mm:ss.fffff",
"yyyy-MM-dd'T'HH:mm:ss.ffffff",
"yyyy-MM-dd'T'hh:mm:ss.ffffff",
"yyyy-MM-dd'T'HH:mm:ss.fffffff",
"yyyy-MM-dd'T'hh:mm:ss.fffffff",
"yyyy-MM-dd'T'HH:mm:ss.ffffffff",
"yyyy-MM-dd'T'hh:mm:ss.ffffffff",
"yyyy-MM-dd'T'HH:mm:ss.fffffffff",
“yyyy-MM-dd'T'hh:mm:ss.fffffffff",
"yyyy-dd-MM HH:mm:ss",
"yyyy-dd-MM hh:mm:ss",
"yyyy-dd-MM HH:mm:ss.f",
"yyyy-dd-MM hh:mm:ss.f",
"yyyy-dd-MM HH:mm:ss.ff",
"yyyy-dd-MM hh:mm:ss.ff",
"yyyy-dd-MM HH:mm:ss.fff",
"yyyy-dd-MM hh:mm:ss.fff",
"yyyy-dd-MM hh:mm:ss tt",
"yyyy-dd-MM hh:mm:ss tt zzz",
"yyyy-dd-MM'T'HH:mm:ss.fff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.fff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.fff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.fff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.ffff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.ffff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.fffff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.fffff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.ffffff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.ffffff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.fffffff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.fffffff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.ffffffff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.ffffffff'Z'",
"yyyy-dd-MM'T'HH:mm:ss.fffffffff'Z'",
"yyyy-dd-MM'T'hh:mm:ss.fffffffff'Z'",
"yyyy-dd-MM HH:mm:ss.fff",
"yyyy-dd-MM hh:mm:ss.fff",
"yyyy-dd-MM HH:mm:ss.ffff",
"yyyy-dd-MM hh:mm:ss.ffff",
"yyyy-dd-MM HH:mm:ss.fffff",
"yyyy-dd-MM hh:mm:ss.fffff",
"yyyy-dd-MM HH:mm:ss.ffffff",
"yyyy-dd-MM hh:mm:ss.ffffff",
"yyyy-dd-MM HH:mm:ss.fffffff",
"yyyy-dd-MM hh:mm:ss.fffffff",
"yyyy-dd-MM HH:mm:ss.ffffffff",
"yyyy-dd-MM hh:mm:ss.ffffffff",
"yyyy-dd-MM HH:mm:ss.fffffffff",
"yyyy-dd-MM hh:mm:ss.fffffffff",
"yyyy-dd-MM'T'HH:mm:ss.fff",
"yyyy-dd-MM'T'hh:mm:ss.fff",
"yyyy-dd-MM'T'HH:mm:ss.ffff",
"yyyy-dd-MM'T'hh:mm:ss.ffff",
"yyyy-dd-MM'T'HH:mm:ss.fffff",
"yyyy-dd-MM'T'hh:mm:ss.fffff",
"yyyy-dd-MM'T'HH:mm:ss.ffffff",
"yyyy-dd-MM'T'hh:mm:ss.ffffff",
"yyyy-dd-MM'T'HH:mm:ss.fffffff",
"yyyy-dd-MM'T'hh:mm:ss.fffffff",
"yyyy-dd-MM'T'HH:mm:ss.ffffffff",
"yyyy-dd-MM'T'hh:mm:ss.ffffffff",
"yyyy-dd-MM'T'HH:mm:ss.fffffffff",
“yyyy-dd-MM'T'hh:mm:ss.fffffffff",
"yy/MM/dd HH:mm",
"yy/MM/dd hh:mm”,
"yy-dd-MM HH:mm:ss",
"yy-dd-MM hh:mm:ss",
"yy-dd-MM HH:mm:ss.f",
"yy-dd-MM hh:mm:ss.f",
"yy-dd-MM HH:mm:ss.ff",
"yy-dd-MM hh:mm:ss.ff",
"yy-dd-MM HH:mm:ss.fff",
"yy-dd-MM hh:mm:ss.fff",
"yy-dd-MM hh:mm:ss tt",
"yy-dd-MM hh:mm:ss tt zzz",
"yy-dd-MM'T'HH:mm:ss.fff'Z'",
"yy-dd-MM'T'hh:mm:ss.fff'Z'",
"yy-dd-MM'T'HH:mm:ss.fff'Z'",
"yy-dd-MM'T'hh:mm:ss.fff'Z'",
"yy-dd-MM'T'HH:mm:ss.ffff'Z'",
"yy-dd-MM'T'hh:mm:ss.ffff'Z'",
"yy-dd-MM'T'HH:mm:ss.fffff'Z'",
"yy-dd-MM'T'hh:mm:ss.fffff'Z'",
"yy-dd-MM'T'HH:mm:ss.ffffff'Z'",
"yy-dd-MM'T'hh:mm:ss.ffffff'Z'",
"yy-dd-MM'T'HH:mm:ss.fffffff'Z'",
"yy-dd-MM'T'hh:mm:ss.fffffff'Z'",
"yy-dd-MM'T'HH:mm:ss.ffffffff'Z'",
"yy-dd-MM'T'hh:mm:ss.ffffffff'Z'",
"yy-dd-MM'T'HH:mm:ss.fffffffff'Z'",
"yy-dd-MM'T'hh:mm:ss.fffffffff'Z'",
"yy-dd-MM HH:mm:ss.fff",
"yy-dd-MM hh:mm:ss.fff",
"yy-dd-MM HH:mm:ss.ffff",
"yy-dd-MM hh:mm:ss.ffff",
"yy-dd-MM HH:mm:ss.fffff",
"yy-dd-MM hh:mm:ss.fffff",
"yy-dd-MM HH:mm:ss.ffffff",
"yy-dd-MM hh:mm:ss.ffffff",
"yy-dd-MM HH:mm:ss.fffffff",
"yy-dd-MM hh:mm:ss.fffffff",
"yy-dd-MM HH:mm:ss.ffffffff",
"yy-dd-MM hh:mm:ss.ffffffff",
"yy-dd-MM HH:mm:ss.fffffffff",
"yy-dd-MM hh:mm:ss.fffffffff",
"yy-dd-MM'T'HH:mm:ss.fff",
"yy-dd-MM'T'hh:mm:ss.fff",
"yy-dd-MM'T'HH:mm:ss.ffff",
"yy-dd-MM'T'hh:mm:ss.ffff",
"yy-dd-MM'T'HH:mm:ss.fffff",
"yy-dd-MM'T'hh:mm:ss.fffff",
"yy-dd-MM'T'HH:mm:ss.ffffff",
"yy-dd-MM'T'hh:mm:ss.ffffff",
"yy-dd-MM'T'HH:mm:ss.fffffff",
"yy-dd-MM'T'hh:mm:ss.fffffff",
"yy-dd-MM'T'HH:mm:ss.ffffffff",
"yy-dd-MM'T'hh:mm:ss.ffffffff",
"yy-dd-MM'T'HH:mm:ss.fffffffff",
“yy-dd-MM'T'hh:mm:ss.fffffffff",
"yy-MM-dd HH:mm:ss",
"yy-MM-dd hh:mm:ss",
"yy-MM-dd HH:mm:ss.f",
"yy-MM-dd hh:mm:ss.f",
"yy-MM-dd HH:mm:ss.ff",
"yy-MM-dd hh:mm:ss.ff",
"yy-MM-dd HH:mm:ss.fff",
"yy-MM-dd hh:mm:ss.fff",
"yy-MM-dd hh:mm:ss tt",
"yy-MM-dd hh:mm:ss tt zzz",
"yy-MM-dd'T'HH:mm",
"yy-MM-dd'T'hh:mm",
"yy-MM-dd'T'HH:mm:ss.fff'Z'",
"yy-MM-dd'T'hh:mm:ss.fff'Z'",
"yy-MM-dd'T'HH:mm:ss.fff'Z'",
"yy-MM-dd'T'hh:mm:ss.fff'Z'",
"yy-MM-dd'T'HH:mm:ss.ffff'Z'",
"yy-MM-dd'T'hh:mm:ss.ffff'Z'",
"yy-MM-dd'T'HH:mm:ss.fffff'Z'",
"yy-MM-dd'T'hh:mm:ss.fffff'Z'",
"yy-MM-dd'T'HH:mm:ss.ffffff'Z'",
"yy-MM-dd'T'hh:mm:ss.ffffff'Z'",
"yy-MM-dd'T'HH:mm:ss.fffffff'Z'",
"yy-MM-dd'T'hh:mm:ss.fffffff'Z'",
"yy--dd'T'HH:mm:ss.ffffffff'Z'",
"yy-MM-dd'T'hh:mm:ss.ffffffff'Z'",
"yy-MM-dd'T'HH:mm:ss.fffffffff'Z'",
"yy-MM-dd'T'hh:mm:ss.fffffffff'Z'",
"yy-MM-dd HH:mm:ss.fff",
"yy-MM-dd hh:mm:ss.fff",
"yy-MM-dd HH:mm:ss.ffff",
"yy-MM-dd hh:mm:ss.ffff",
"yy-MM-dd HH:mm:ss.fffff",
"yy-MM-dd hh:mm:ss.fffff",
"yy-MM-dd HH:mm:ss.ffffff",
"yy-MM-dd hh:mm:ss.ffffff",
"yy-MM-dd HH:mm:ss.fffffff",
"yy-MM-dd hh:mm:ss.fffffff",
"yy-MM-dd HH:mm:ss.ffffffff",
"yy-MM-dd hh:mm:ss.ffffffff",
"yy-MM-dd HH:mm:ss.fffffffff",
"yy-MM-dd hh:mm:ss.fffffffff",
"yy-MM-dd'T'HH:mm:ss.fff",
"yy-MM-dd'T'hh:mm:ss.fff",
"yy-MM-dd'T'HH:mm:ss.ffff",
"yy-MM-dd'T'hh:mm:ss.ffff",
"yy-MM-dd'T'HH:mm:ss.fffff",
"yy-MM-dd'T'hh:mm:ss.fffff",
"yy-MM-dd'T'HH:mm:ss.ffffff",
"yy-MM-dd'T'hh:mm:ss.ffffff",
"yy-MM-dd'T'HH:mm:ss.fffffff",
"yy-MM-dd'T'hh:mm:ss.fffffff",
"yy-MM-dd'T'HH:mm:ss.ffffffff",
"yy-MM-dd'T'hh:mm:ss.ffffffff",
"yy-MM-dd'T'HH:mm:ss.fffffffff",
"yy-MM-dd'T'hh:mm:ss.fffffffff",

Addditional Formats

"d", "D", "dd", "ddd", "dddd",
"g", "G",
"h", "hh", "H", "HH",
"K",
"f", "F", "ff", "fff", "ffff", "fffff", "ffffff", "fffffff", "FF", "FFF", "FFFF", "FFFFF", "FFFFFF", "FFFFFFF",
"m", "M", "MM", "mm", "MMM", "MMMM",
"o", "O",
"r", "R",
"s", "ss",
"t", "T", "tt",
"U", "u",
"y", "Y", "yy", "yyyy", "yyyyy",
"z", "zz", "zzz",
":", "//",

Loading Your Data

Supported File Types

To Load Data into Virtualitics Explore Desktop:

Video Tutorial

Accepted Time and Date Formats

Related articles