Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

sql postgresql casting timestamp

postgresql

Change type of varchar field to integer: "cannot be cast automatically to type integer"

postgresql casting postgresql-9.1 fieldtype

postgresql

How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?

sql postgresql casting

postgresql

SQL: Subtracting 1 day from a timestamp date

sql postgresql date casting timestamp

postgresql

Double colon (::) notation in SQL

sql postgresql casting

postgresql

PostgreSQL: ERROR: operator does not exist: integer = character varying

postgresql casting integer varchar

postgresql

What does :: do in PostgreSQL? [duplicate]

postgresql syntax types casting typecast-operator

postgresql

Discard millisecond part from timestamp

sql postgresql casting timestamp rounding

postgresql

Order varchar string as numeric

postgresql types casting indexing integer

postgresql

PostgreSQL : cast string to date DD/MM/YYYY

string postgresql date casting

postgresql

Convert hex in text representation to decimal number

postgresql types casting hex

postgresql

Postgres data type cast

java sql postgresql casting

postgresql

Rails Migrations: tried to change the type of column from string to integer

ruby-on-rails ruby postgresql casting rails-migrations

postgresql

How to cast string value to enum

postgresql casting enums

postgresql

No function matches the given name and argument types

function postgresql types casting plpgsql

postgresql