Date Representation

SmartStore does not define a date/time data type. When you create index specs for date/time fields, choose a SmartStore type that matches the format of your JSON input. For example, Salesforce sends dates as strings, so always use a string index spec for Salesforce date fields. To choose an index type for non-Salesforce or custom date fields, consult the following table.

TypeFormat AsDescription
stringAn ISO 8601 string"YYYY-MM-DD HH:MM.SSS"
floatingA Julian day numberThe number of days since noon in Greenwich on November 24, 4714 BC according to the proleptic Gregorian calendar. This value can include partial days that are expressed as decimal fractions.
integerUnix timeThe number of seconds since 1970-01-01 00:00:00 UTC