How change date format through SQL

J

Jeff Homan

Hello,

I have an existing database in Access 97, all of the dates are stored
as 10/25/2004 (Month / Day / Year). Is there a way to change the
format via SQL that would change it to 2004-10-24 (Year-Month-Day)?

Thank you,
Jeff Homan

www.jcswebhosting.com
 
R

Rick B

I don't think dates are not stored in the format you mention. They are
stored as a number that Access decodes.

You control how the date looks by setting the format in your reportsm
queries and forms.

The date that you see in a table view is most likely controlled by your
Microsoft Windows global settings.

Hope that helps.

Rick B
 
Top