In my research I have found that SQL doesn't really store the datetime values the way it looks in query anaylzer or enteprise manager.<BR><BR>Here's where I might be getting off the right track.

Send the prompt to OpenAI’s GPT-3.5-turbo API and request an SQL query to answer your question. Run the SQL that comes back on your data set to calculate your answer.

Thanks for the info all.<BR><BR>For my current need, a trimmed format did the trick but I'll keep in mind datepart and datename.

SQL, on the other hand, is still being used as part of work around AI, analytics, and software development. It continues to be the standard for how we interact with data on a daily basis.