So I am querying the SETTLEMENTDATE column of my database (BIDDAYOFFER) and I only want to query the date and not the time component.
For example I only want to query “2021-05-24” instead of “2021-05-24 09:30:00”.
This is my current query:
CAST(SETTLEMENTDATE AS Date) AS “time”,
PRICEBAND1, PRICEBAND2, PRICEBAND3, PRICEBAND4, PRICEBAND5, PRICEBAND6, PRICEBAND7, PRICEBAND8, PRICEBAND9, PRICEBAND10
WHERE DUID = “SUNRSF1” AND SETTLEMENTDATE = CURDATE()
ORDER BY LASTCHANGED DESC
Where the following table is being outputted on my graph:
Could someone please help me edit my query so that only the date part of “SETTLEMENTDATE” is outputted in my grafana.