A. The SQL date/time field stores a date and time but if you have a populated table and you want to convert a column so it lists data only run the following:


where =convert(datetime,convert(char(10),,101))

For example

update faq
where created=convert(datetime,convert(char(10),created,101))

Read more FAQs.

Also, learn more about how to ORDER BY different fields based on a variable in SQL Server and how to encrypt fields in SQL Server.

Publication Info

Sponsored Introduction Continue on to (or wait seconds) ×