I have a datetime
column in SQL Server that gives me data like this 10/27/2010 12:57:49 pm
and I want to query this column but just have SQL Server return the day month and year - eg. 2010 10 27
or something like that.
What are the functions I should be researching?
Should I be trying to convert to another date data type? Or simply convert it to a string?