I'm working with SQL Server 2005.
I have a column called purchase_time of type datetime. How do I select this column with the time part - just the date.
Thanks,
Barry
EDIT: Would it be safe to get the datetime and split it via Python on the first space, or is this format locale dependant?
See Question&Answers more detail:os