Type datetime can be used to store a value with date and time information.

The datetime and 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.

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.

Converting a datetime or timeval type to type int or float will return the UNIX time-stamp. For example: int(datetime('2013-06-02T00:00:00Z')) returns the int value 1370131200.


Function Description
extract Return a thing with second, minute, hour, day, month, year and gmt_offset as individual properties.
format Returns a string representation using a custom format string.
move Return a new datetime which is shifted in time relative to the original date/time.
replace Return a new datetime with new values for given time units.
to Return a new datetime with new time zone information.
week Return the week of the year as an integer between 0..53. Week 1 starts at the first Sunday in January.
weekday Return the number of days (0..6) since the last Sunday.
yday Return the day in the year as an integer value between 0..365 where the first of January is day 0.
zone Return the time zone as a string, of nil if not zone information is available.
Function Description
datetime Create a new datetime value.
is_datetime Test if a given value is of type datetime.