![]() ![]() The following SQL statement selects all the customers from the department "sales," in the "employees" collection: 1 This is generally only necessary when your identifier doesn't fit the rules for simple identifiers. Double quotes delimit identifiers e.g., collection names or column names. Single quotes delimit a string constant or a date/time constant. In NoSQLBooster, we follow ANSI SQL standard. Please follow this link to learn more about MongoDB date aggregation operators. The first parameter is formatString, single quotes, the second parameter is "Date Field", double quotes. 1ĭateToString( '%Y-%m-%d', "hire_date") as hiredate The $dateToString expression has the following syntax: 1Īs SQL functions doesn't support JSON object parameter, NoSQLBooster for MongoDB converts the object param as plain parameter list. The dateToString is another MongoDB date operator to convert a date object to a string according to a user-specified format. #If a time part is included, an offset from UTC can also be included as +-HH:mm, +-HHmm, +-HH or Z. 09:30:26 # An hour, minute, and second time part #A time part can also be included, separated from the date part by a space or an uppercase T. # An ISO 8601 string requires a date part. Please refer to Moment.js parse string document to view all supported string formats. When creating a date from a string, Moment.js first check if the string matches the known ISO 8601 formats, Moment.js then check if the string matches the RFC 2822 Date time format before dropping to the fall back of new Date(string) if a known format is not found. NoSQLBooster for MongoDB uses Moment.js to parse date string. The date function converts a string to a MongoDB Date type.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |