Is there a way that I can ensure the curdate function always uses EST time zome to return the correct date? For instance, at 8:50 pm, the cur date function is displaying 2/4 when I want it to display 2/3.
CURDATE returns the current date in UTC format. If you want to convert it to EST you'll need to subtract hours from the UTC time to get EST time.