Hi,I have a field (varchar) field that holds date. Some data was transferred to this column but the transferred data was a timestamp (datetime in the format of say 10/26/2009 4:54:13 AM). Now, I need to modify the new table to only contain 10/26/2009. How can I write a statement to delete the time leavin gonly 10/26/2009?? I can use trim function but the # of characters vary as the date might be 1/10/2010 12:50:00 PM, etc....?thanks .
View Complete Post