For my dialect (Ontario, Canada), I would only say "what day is it today" or "what's the date today". "What day is today" sounds like it is missing a word to me. Based on the other comments this is clearly not universal.

Both of them are grammatically correct.

both can be used, feel free to message if you like to talk more, or have questions :)

Both and you'll hear both all the time