How change date format through SQL

  • Thread starter Thread starter Jeff Homan
  • Start date Start date
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
 
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
 
Back
Top