How Can I compare table column by convert it first in postgresql + typeorm

Viewed 62

I am beginner in Backend technology and I am developing one query in Typeorm QueryBuilder + PostgreSQL.

My query is look like this :

YYYY-MM-DD

But I can't convert my timestamp into following format. Can anyone who has expertise in it, please help me to select all records with timestamp in specific format.

I am suffering this things from last two days but still not find any solution. Actually I want to compare this date format in having clause. so I want to first select that date format then I can use that same method to compare column with current date and previous dates.

0 Answers
Related