datetime can be used to store a value with date and time information.
timeval types have second precision. If more than second precision is required you will have to
use your own type. For example the function now() returns the current time-stamp as a floating point type.
datetime will appear as an ISO8601 formatted string in query results. It might be more convenient to get the value as a UNIX time-stamp instead.
If so, you might want to look at the timeval type which is created for this purpose.
timeval type to type int or float will return the UNIX time-stamp.
int(datetime('2013-06-02T00:00:00Z')) returns the int value
|format||Returns a string representation using a custom format string.|
|move||Return a new
|replace||Return a new
|to||Return a new
|week||Return the week of the year as an integer between
|weekday||Return the number of days (
|yday||Return the day in the year as an integer value between
|zone||Return the time zone as a string, of
|datetime||Create a new datetime value.|
|is_datetime||Test if a given value is of type datetime.|