>Is there a way to convert datetime to date fields in SPT cursor?

Would TTOD() do what you want?

SELECT TTOD(tMyDateTime) AS dMyDate...