RajKishore 
As a database consultant working with PostgreSQL, I’ve recently had a requirement to convert timestamp values to dates for one of the applications. In this comprehensive guide, I’ll share the multiple methods to convert PostgreSQL timestamps to dates, including the pros and cons of each approach. PostgreSQL Cast Timestamp To Date Before diving into conversion … Read more >>
Recently, I got a requirement to work with Postgres date range functionality. I have identified a few key approaches to achieve this functionality. This PostgreSQL tutorial teaches us about the “Postgres date range” and covers the following topics. Postgres date range Let us understand this topic deeply with an example. In PostgreSQL, create a table named employee … Read more >>
In this PostgreSQL tutorial, we will learn about “PostgreSQL cast int” using different data types or functions and casting or converting from int to another data type, such as boolean, float, timestamp, etc. PostgreSQL Cast Int When data is stored in a PostgreSQL database, we want to convert the data type of a value or column in the table into … Read more >>
In this comprehensive guide, I’ll cover everything you need to know about generating date ranges in PostgreSQL, from basic techniques to advanced patterns. Postgres Generate Date Range PostgreSQL provides a generate_series() function that allows you to create a sequential series of values, including dates and timestamps. The generate_series() function is incredibly flexible when it comes … Read more >>
In this PostgreSQL tutorial, I will show you how to format numbers in PostgreSQL, where you will understand different functions provided by PostgreSQL such as to_char, round() and etc. Additionally, you will understand how to use lpad() function with the numeric value, and use the to_char() function to format the numeric value with the currency … Read more >>
Mastering inner joins is essential for anyone working with relational databases. In this comprehensive article, I’ll share my expertise on implementing multiple inner joins in PostgreSQL. PostgreSQL Multiple Inner Joins Now, we will understand how multiple inner joins are implemented in Postgresql using the psql tool. In PostgreSQL, the INNER JOIN will select all rows from both … Read more >>
A multiple join is a query that contains similar or different join types that are used more than once. In this comprehensive article, I’ll walk you through everything you need about using multiple joins in PostgreSQL – from basic concepts to advanced approaches. PostgreSQL multiple joins Using multiple joins in PostgreSQL, we can combine various … Read more >>
In this PostgreSQL tutorial, we will learn about PostgreSQL Joins. Here we will learn how to use joins in PostgreSQL and PostgreSQL Joins Types. PostgreSQL Joins PostgreSQL joins are used to merge columns from one (self-join) or more tables based on the values of the common columns between related tables. The standard columns are generally the … Read more >>
As a database consultant, I’ve encountered many developers confused about timestamp functions in PostgreSQL. One question that repeatedly comes up is: “What is the difference between current_timestamp and now() in PostgreSQL” PostgreSQL current_timestamp vs now Let’s start with the short answer: current_timestamp and now(). They are functionally equivalent in PostgreSQL. They both return the current … Read more >>
In this PostgreSQL tutorial, I show you how to use PostgreSQL current_timestamp to get the current timestamp of the system. Also, I will show you the way to control the format and convert the timestamp value returned by the CURRENT_TIMESTAMP to the UTC time zone. PostgreSQL current_timestamp PostgreSQL has the function current_timestamp to get time … Read more >>