aaronjonmartin
Technical User
I have a table which contains a column which is a datetime column, and contains dates in the format dd/mm/yy hh:mm:ss.
I am using a stored procedure to select the dates from this table. However i wish to format them differently. I want the stored procedure to change the formatting of the dates to mm/dd/yy hh:mm:ss. Is this possible? I dont want to change them in the database, just the format they are returned in from this one stored procedure.
Any help with this would be most appreciated.
Aaron
"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)
I am using a stored procedure to select the dates from this table. However i wish to format them differently. I want the stored procedure to change the formatting of the dates to mm/dd/yy hh:mm:ss. Is this possible? I dont want to change them in the database, just the format they are returned in from this one stored procedure.
Any help with this would be most appreciated.
Aaron
"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)