The formats that you can use for date or time inputs to mashables depend on what individual mashables support. In most cases, you should consult mashable source documentation or ask your Presto administrator for information on valid date and time formats.

For inputs to mashups, Presto uses the datetime format: YYYY-MM-DDThh:mm:ss.szzzzzz. This is the XML dateTime datatype which is based on the ISO 8601 standard. If no time information is defined in the input, Presto treats this as just a date. No default time is assigned.