Loading your dataset is the first step to diving into your data in Virtualitics Explore. Virtualitics Explore 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.
Supported File Types
Virtualitics Explore 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) | Note: 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 project with a “.vip” extension |
To Load Data into Virtualitics Explore:
- From the Virtualitics Explore Home Page, click the Add Data button. Alternatively, click the Main Menu (
) in the top left-hand corner.
- Select your data source:
| Upload File |
Load a local file or Virtualitics Explore project file (.vip). |
| Query Data Source | Load from a remote database. Options include:
|
| Load Project (Main Menu) | Load a previously saved Virtualitics Explore project file (.vip). |
Note: If you choose to connect to a remote database, you will need to set up a connection. For more on loading remote data into Virtualitics Explore, see this article.
- 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 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.
To Load Data Using My Files:
On the Virtualitics Explore Home Page, My Files allows you to quickly open sample datasets or any previously-loaded projects or datasets.
You can search for any project or dataset by typing its name into the Search bar. Any associated files will automatically appear.
You can also toggle between visible file types by clicking the drop-down menu to the right of the Search bar and selecting:
- All Files (default): show all sample datasets and previously-loaded files
- Projects: show only .vip project files
- Datasets: show only previously-loaded dataset files
To load one of these files:
- Under the My Files list, click a file name. This will open the Dataset Preview window.
- In the Dataset Preview window, click Load Dataset.
Note: Loaded projects and datasets are stored in the cloud for easier and quicker access. You can see how much cloud storage is remaining by reviewing your Storage capacity, located beneath the My Files section.
Accepted Time and Date Formats
Virtualitics Explore 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)
"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",
"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",
"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",
"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",
"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",
"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",
"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",
":", "//",
|
Next Article |