<div>
What is the actual datatype of the column? &nbsp;Is it actually a date datatype? &nbsp;If so, then there is no format. &nbsp;What you are looking at is a display format. &nbsp;You can easily change that. &nbsp;Try looking at the <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-ver15" rel="ugc">FORMAT</a> function.<br />
<br />
If it is a string format, you would be best served by using substrings and rebuilding the string to get what you want, but it could easily be done in a single update.
</div>


<div>
It is a date datatype in a table I'm importing into Access. In Access, when adding a criteria in a query using that table do I put the value in quotation marks or number sign i.e. "2020-05-10" or #2020-05-10#?
</div>


SpaceCoastLife

EE Topic Advisor

PortletPaul

<div>
So, this is an Access question. &nbsp;Once you import data into a database, where it came from is no longer relevant.<br />
<br />
Same answer essentially applies. &nbsp;Access stores dates in an internal format. &nbsp;There is no display format associated with it. &nbsp;If you are storing it as a date in Access, then whatever the Access format is for querying a date applies. &nbsp;Seems like the # is the correct way, but I don't really use Access at all.
</div>


<div>
The best you can do is to leave the SQL Server column unchanged. It ensures no date ambiguity.<br>Use the <a href="https://support.office.com/en-us/article/format-function-6f29d87b-8761-408d-81d3-63b9cd842530" rel="ugc">Format()</a> function at the Access side to format the output to whatever you need.<br>Of course, depending on your Access version the datetime column provides better compatibility.<br><br>To query the SQL table use the format "2020-05-10". It should be converted correctly. Just give it a try.<br><br>
</div>


<div>
You have to know that SQL Server Management Studio always shows date in format YYYY-MM-DD.<br>But Access display the date based on the Windows regional settings of the current user.<br>So you have to understand that the display format of data is just the rendering of date and it can be different at different users but the date value itself is permanent.<br>However access accepts date filtering on your current date settings so: #MM/DD/YYYY#.
</div>


<div>
<div class="content wysiwyg-content">
How do I convert a SQL Server db table (thousands of records) with a date field formatted as YYYY-MM-DD into a format of MM/DD/YYYY either in the same field or a new one?
</div>
</div>


How do I convert a SQL Server db table (thousands of records) with a date field formatted as YYYY-MM-DD into a format of MM/DD/YYYY either in the same field or a new one?

Modify the format of a date field in a table with thousands of records to another date format

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.