Return audit date to date type 110

I am trying to write a query that will return the 'Audit Date' field as MM-DD-YYYY. I searched a few forums, but can only find how to convert the current date in that format. How do I return all dates in this format?

Here is what I found to convert the current date:

convert(varchar, getdate(), 110)

Thanks in advance!

Answers


See the msdn doc for Convert and Cast

SELECT convert(varchar, [audit date], 110) as audit_date
FROM [your table here]

Need Your Help

How to implement row numbering into h:dataTable

java jsf jsf-2

I have this JSF table with pagination.

Injecting code into APK

android code-injection apk

I know you can decompile code using apktool and recompile it again, but my question is how would you be able to inject large amounts of code into an apk and execute it.