Note that this function is evaluated on every invocation and may returnĭifferent values when invoked multiple times in the same query. The return value has millisecond precision. returns timestamp (number): the current unix time as a timestamp.Get the current unix time as numeric timestamp. Most certainly not be of any help for such dates, but you can still use languageĬonstructs like SORT (which also supports sorting of arrays)Īnd indexes. The like in different, more appropriate ways of course. ARANGODB AQL FUNCTIONS FREEYou are free to store age determinations of specimens, incomplete or fuzzy dates and This alsoĪpplies to operations which produce an invalid value.ĭATE_HOUR ( 2 * 60 * 60 * 1000 ) // 2 DATE_HOUR ( "T02:00:00" ) // 2 Which can optionally be escalated to an error and abort the query. "T23:59:59.999Z" (inclusive)Īny date/time values outside the valid range that are passed into an AQL dateįunction will make the function return null and trigger a warning for the query, Meaning May 7th 2014, 14:19:09 and 522 milliseconds, UTC / Zulu time.Īnother example value without time component is Z. Alternatively to an offset, a Z can be used Hours and minutes that need to be added or subtracted to the date time value.įor example, T14:19:09+01:00 can be used to specify a one hour offset,Īnd T14:19:09+07:30 can be specified for seven and half hours offset. Year ( YYYY), month ( MM) and day ( DD) can be left out, but is discouraged.Ī time offset may optionally be added at the end of the string, with the zero-padding is requiredįor the values 0 through 9 (e.g. Minutes ( MM) and seconds ( SS) are mandatory, i.e. Numeric timestamps, millisecond precision.Īn example timestamp value is 1399472349522, which translates to year: one year is defined as 365.2425 daysĪll functions that require dates as arguments accept the following input values:.month: one month is defined as 1/12 of a year.hour: one hour is defined as 60 minutes.minute: one minute is defined as 60 seconds.The date functions use millisecond precision for timestamps. A timestamp has the same valueĪt every point on earth. Unix time countsĪll non leap seconds beginning with January 1st 1970 00:00:00.000 UTC, also know as Instead, dates in AQL are represented by either numbers or strings.Īll date function operations are done in the Unix time system. AQL offers functionality to work with dates, but it does not have a special data typeįor dates (neither does JSON, which is usually used as format to ship data into and
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |