Date Parse in Query JSON with sql

💬 Queries and Resources
2

Hi @Tommy_Fiacco - welcome to the community!

Try adjusting your initial SQL to be like this:

AND TO_TIMESTAMP(tickets.created_at, 'YYYY-MM-DD"T"HH24:MI:SS"Z"')::date >= {{ dateRange1.value.start }}

In this query, TO_TIMESTAMP function is used to convert the created_at string to a timestamp with the specified format. Then, the ::date operator is used to extract the date part from the timestamp.

Let me know if that works for you