SELECT convert(varchar, your_data_here ,1)
Select allOpen in new window
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
(Potentially stupid question) Doesn't .ASP have the ability to format dates? SQL Server can do this formatting but it will return it as a varchar column and not a date column, which will impact any date math and sorting on the front-end.
Open in new window