SqlHydra icon indicating copy to clipboard operation
SqlHydra copied to clipboard

Is it possible call `date_trunc` from PostgreSQL?

Open MangelMaxime opened this issue 8 months ago • 7 comments

In SQL, I want to write something like

SELECT date_trunc('day', fsvr."CompletedTimeStamp"), fsvr."FormSpecType", count(fsvr."FormSpecType")
FROM dbo."FormStudioValuesResult" AS fsvr
WHERE fsvr."TenantId" = '9003665c-a1c3-486e-90db-85f7a053ded8'
group by 1, fsvr."FormSpecType";

Is it possible to do something similar with SqlHydra or to have access to its internal so the user can extends it if needed ?

MangelMaxime avatar Jun 17 '24 19:06 MangelMaxime