Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hey there is there a way to format date column to 'dd.mm.yyyy' and filter it using LIKE  operator ?

cause i need to filter record by date in application

app should show all records where day is 08

shows all records where day is 18 month is 1 and years starts with 20

but dates are stored in different format and i cant use LIKE because they are not text

That's an interesting requirement, but sure - you can add a generated column to your table and filter on that

could you send me something where i can get to know more about this generated column and filtering ?

You can either use a function with a PostgREST Computed Columns: https://postgrest.org/en/stable/api.html#computed-columns

Or use PostgreSQL's Generated Columns: https://www.postgresql.org/docs/14/ddl-generated-columns.html

the first one is computed on demand, the second is stored in your table