Postgresql

Data-type Conversion in PostgreSQL

Data Type Conversion¶ Let us understand how we can type cast to change the data type of extracted value to its original type. In [1]: %load_ext sql In [2]: %env DATABASE_URL=postgresql://itversity_retail_user:retail_password@pg.itversity.com:5432/itversity_retail_db env: DATABASE_URL=postgresql://itversity_retail_user:retail_password@pg.itversity.com:5432/itversity_retail_db In [3]: %%sql SELECT ’09’::int 1 rows affected. Out[3]: int4 9 In [4]: %%sql SELECT current_date AS current_date * postgresql://itversity_retail_user:***@pg.itversity.com:5432/itversity_retail_db 1 rows affected. Out[4]: current_date 2022-03-14 …

Data-type Conversion in PostgreSQL Read More »

Data Manipulation Functions in PostgreSQL

Date Manipulation Functions¶ Let us go through some of the important date manipulation functions. Getting Current Date and Timestamp Date Arithmetic using INTERVAL and – operator Getting beginning date or time using date_trunc Extracting information using to_char as well as calendar functions. Dealing with unix timestamp using from_unixtime, to_unix_timestamp Getting Current Date and Timestamp¶ Let …

Data Manipulation Functions in PostgreSQL Read More »