Build dashboards & reports in minutes

  • Features
  • Pricing
  • Blog
  • What is Ubiq
  • Free Trial

How to Convert datetime to UTC in MySQL

January 14, 2021January 14, 2021 Ubiq MySQL
convert datetime to utc in mysql

Sometimes you may need to set timezone to UTC or change timezone to UTC. Here is how to convert datetime to UTC in MySQL

Continue reading


How to Insert into Array in PostgreSQL

January 5, 2021January 5, 2021 Ubiq PostgreSQL
how to insert into array in postgresql

PostgreSQL allows you to select into array, append to array and insert array of objects. Here is how to insert into array in PostgreSQL.

Continue reading


How to Convert UTC to Local Time in MySQL

January 1, 2021January 1, 2021 Ubiq MySQL
convert utc to local time in mysql

Sometimes you may need to change UTC to local time in MySQL. Here is how to convert UTC to local time in MySQL.

Continue reading


How to Create Array in PostgreSQL

December 21, 2020January 5, 2021 Ubiq PostgreSQL
create array in postgresql

PostgreSQL allows you to store array or create arrays with range. Here is how to create array in PostgreSQL.

Continue reading


How to Get Current Date and Time in MySQL

December 21, 2020December 21, 2020 Ubiq MySQL
get current date and time in mysql

Sometimes you may need to get date from datetime, or get current datetime. Here is how to get current date and time in MySQL.

Continue reading


How to Convert String Case in PostgreSQL

December 17, 2020December 17, 2020 Ubiq PostgreSQL
convert string case in postgresql

Sometimes you may need to convert lowercase to uppercase or uppercase to lowercase. Here is how to convert case of string in PostgreSQL

Continue reading


How to Group By Month in MySQL

December 16, 2020December 16, 2020 Ubiq MySQL
group by month in mysql

Sometimes you may need to aggregate by month in MySQL. Here is how to group by month in MySQL.

Continue reading


How to Concatenate Strings in PostgreSQL

December 15, 2020December 15, 2020 Ubiq PostgreSQL
how to concatenate string in postgresql

You can easily concatenate columns & strings in PostgreSQL. Here is how to concatenate strings in PostgreSQL.

Continue reading


How to Remove Not Null Constraint in MySQL

December 14, 2020December 14, 2020 Ubiq MySQL
remove not null constraint in mysql

MySQL allows you to remove NOT NULL constraint in MySQL. Here is how to remove NOT NULL constraint in MySQL.

Continue reading


How to Remove Default Value of Column in MySQL

December 10, 2020December 10, 2020 Ubiq MySQL
remove default value in mysql

Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL

Continue reading


Page 3 of 24«12345...1020...»Last »

About Us



Ubiq is a business intelligence & reporting software. Build business dashboards, charts & reports in minutes. Get insights from data quickly. Try it for free!




Data Reporting
  • MySQL Reporting Tools
  • PostgreSQL Reporting Tools
  • Online Reporting Tools
  • Web Reporting Tools
  • Redshift BI Reporting
  • SQL Reporting Tools
Business Intelligence
  • BI Solution
  • BI Reporting Software
  • MySQL BI Reporting Tools
  • Self Service BI
  • SaaS BI
Data Visualization
  • Data Visualization Tools
  • Data Analysis Tools
  • Visual Analytics
  • MySQL Charts
  • MySQL Graph Generator
  • MySQL Report Builder
  • Online Report Generator
  • Redshift Data Visualization
Dashboards
  • Dashboard Builder
  • Dashboard Reporting Software
  • Dashboard Creator
  • KPI Dashboard Software
Quicklinks
  • Contact Us
  • Docs
  • Jobs
  • BI Blog
  • Database Blog
  • Tech Blog
Resources
  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress