information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data Default Value Allowed Values printTableName Print table name Boolean true Any formatDateISO Format dates in ISO 8601 Boolean true Any extension File extension String json Any DbUnit ( ) dbunit HTML Language Programming languages String PHP < 5.4 PHP < 5.4 , PHP 5.4+ formatDateISOPHP Format dates in ISO 8601 Boolean true Any extension File extension String php Any quoteChar Quote character

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data Default Value Allowed Values printTableName Print table name Boolean true Any formatDateISO Format dates in ISO 8601 Boolean true Any extension File extension String json Any DbUnit ( ) dbunit HTML Language Programming languages String PHP < 5.4 PHP < 5.4 , PHP 5.4+ formatDateISOPHP Format dates in ISO 8601 Boolean true Any extension File extension String php Any quoteChar Quote character

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data Default Value Allowed Values printTableName Print table name Boolean true Any formatDateISO Format dates in ISO 8601 Boolean true Any extension File extension String json Any Id Name Description Type Language Programming languages String PHP < 5.4 PHP < 5.4 , PHP 5.4+ formatDateISOPHP Format dates in ISO 8601 Boolean true Any extension File extension String php Any quoteChar Quote character

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data Default Value Allowed Values printTableName Print table name Boolean true Any formatDateISO Format dates in ISO 8601 Boolean true Any extension File extension String json Any Id Name Description Type Language Programming languages String PHP < 5.4 PHP < 5.4 , PHP 5.4+ formatDateISOPHP Format dates in ISO 8601 Boolean true Any extension File extension String php Any quoteChar Quote character

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data Default Value Allowed Values printTableName Print table name Boolean true Any formatDateISO Format dates in ISO 8601 Boolean true Any extension File extension String json Any Id Name Description Type Language Programming languages String PHP < 5.4 PHP < 5.4 , PHP 5.4+ formatDateISOPHP Format dates in ISO 8601 Boolean true Any extension File extension String php Any quoteChar Quote character

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data "imdb-details".rating > 6 If you need to operate with dates then you must specify them in an ISO format. It is possible in both the JavaScript and SQL dialect: db.dates.insert([ { value: new Date('2016-05-18T16:00:00Z') JavaScript: db.dates.find({ value: { $gte: new Date('2018-05-18T16:00:00Z') } }).toArray() Querying data in the SQL dialect (ISO and UNIX timestamp, in milliseconds): SELECT value FROM dates WHERE value

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row Working with spatial/GIS data Spatial data "imdb-details".rating > 6 If you need to operate with dates then you must specify them in an ISO format. It is possible in both the JavaScript and SQL dialect: db.dates.insert([ { value: new Date('2016-05-18T16:00:00Z') JavaScript: db.dates.find({ value: { $gte: new Date('2018-05-18T16:00:00Z') } }).toArray() Querying data in the SQL dialect (ISO and UNIX timestamp, in milliseconds): SELECT value FROM dates WHERE value

information will be displayed: Name of the column in the header Displayable data (strings, numbers, dates etc.) from every other column in the corresponding row DBeaver has several predefined map tiles. Default Value Allowed Values printTableName Print table name Boolean true Any formatDateISO Format dates in ISO 8601 Boolean true Any DbUnit ( ) dbunit HTML ( ) html JSON ( ) json DBeaver User Guide Language Programming languages String PHP < 5.4 PHP < 5.4 , PHP 5.4+ formatDateISOPHP Format dates in ISO 8601 Boolean true Any extension File extension String php Any quoteChar Quote character

'imdb-details'.rating > 6 If you need to operate with dates then you must specify them in ISO format. It is possible in both JavaScript and SQL dialect: db.dates.insert([ { value: new Date('2016-05-18T16:00:00Z') JavaScript: db.dates.find({ value: { $gte: new Date('2018-05-18T16:00:00Z') } }).toArray() Querying data in SQL dialect (ISO and UNIX timestamp, in milliseconds): SELECT value FROM dates WHERE value value > ISODate('2018-05-18T16:00:00.000Z') ORDER BY value DESC SELECT value FROM dates WHERE value > ISODate(1526659200000) ORDER BY value DESC When you need to find document by ID you must use function

"imdb-details".rating > 6 If you need to operate with dates then you must specify them in an ISO format. It is possible in both the JavaScript and SQL dialect: db.dates.insert([ { value: new Date('2016-05-18T16:00:00Z') JavaScript: db.dates.find({ value: { $gte: new Date('2018-05-18T16:00:00Z') } }).toArray() Querying data in the SQL dialect (ISO and UNIX timestamp, in milliseconds): SELECT value FROM dates WHERE value ORDER BY value DESC SELECT value FROM dates WHERE value > ISODate(1526659200000) ORDER BY value DESC Executing SQL Conditions Nested fields Working with dates DBeaver User Guide 21.1. Page 267 of