${queryResult.errors.map(error => `

${error.description.split('\n').map(line => line.replace(/ /g, ' ') ).join('
')}

` ).join('')}

`; return; } // Format cell value based on type and value const formatCell = (value, type) => { if (value === null) return 'NULL'; if (Array.isArray(value)) { return `[${value.map(v => v === null ? 'NULL' : v ).join(', ')}]`; } if (type.startsWith('double') || type.startsWith('float')) { return `${value}`; } return value; }; // Create result table HTML const tableHTML = `

${queryResult.rows === 100000 ? '

Results are limited to 100,000 rows.

' : ''} ${queryResult.meta.map(col => `` ).join('')} ${queryResult.data.map(row => ` ${row.map((value, index) => `` ).join('')} `).join('')}

${col.name}
${formatCell(value, queryResult.meta[index].type)}

Rows: ${queryResult.rows} Execution time: ${(queryResult.statistics.elapsed * 1000).toFixed(2)}ms

`; resultsDiv.innerHTML = tableHTML; } catch (error) { console.error('Error:', error); resultsDiv.innerHTML = `

${error.message}

`; resultsDiv.classList.remove('query-window-hidden'); } }

​Date and time functions

Firebolt Core

​Date and time functions

Date and time functions

Date and time functions