What is the unity of time that dbeaver uses in his analitycs?
I’m using dbeaver conected to a postgreSQL to create a SQL Query. And trying to get the analitycs of that execution.
Reconciliation of two tables in SQL using Dbeaver
I am trying to recon two transactional tables.
Table A is the bank report
Table B is the internal report.
Both tables have a matching primary(external_reference_id) and foreign Key (externaltransactionid)
SQL Query not working to get the monday from week number and year
I’ve been struggling to get the Monday from the week number and year number. Can anyone help? I would prefer that there is no reference made to 1900-01-01 because for 2022 the date that my query returns lands on a Saturday while the one for 2023 lands on a Sunday.
sum(nvl not aggregating properly sql
I am using dbeaver 23.3.3 and I am wondering why my SQL query is not aggregating properly and if anyone knows a fix to this?