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. |