Issue with areachart not showing date and time from sql on haxis

[daniel ricci]

i am pulling the time for the haxis of an areachart from mysql. The time is inserted using the timestamp into mysql table. When i run the query with in the chart it will not show anything on the haxis. if i manually put a date like dat(2022, 8, 14, 6, 20,00) it shows up fine. but it will show this for all points. Not sure what to do. DateTime doesnt seem to work. not formating the DateTime