Ubiq BI

How to 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

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

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

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

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

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

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

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

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