Date format
in [Queries]
|
From: Scott_Brasted via AccessMonster.com on 22 Jan 2010 21:57 Greetings, I am putting thisinquery because i think I will have to use a query to get my result. I need to export an Accwss 2000 table to mySQL. The table has a field that is a date. Access uses 12/24/2010. mySQL uses 2010-12-24. I need to change the Access table before I import into mySQL. Does anyone know haw to do this? Best, Scott -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201001/1
From: John W. Vinson on 23 Jan 2010 00:32 On Sat, 23 Jan 2010 02:57:41 GMT, "Scott_Brasted via AccessMonster.com" <u56211(a)uwe> wrote: >Greetings, > >I am putting thisinquery because i think I will have to use a query to get my >result. I need to export an Accwss 2000 table to mySQL. The table has a field >that is a date. Access uses 12/24/2010. mySQL uses 2010-12-24. I need to >change the Access table before I import into mySQL. Does anyone know haw to >do this? You do not need to, nor should you, change the Access table. Instead, create a Query based on the table. In that query, don't include the datefield itself; instead, put in a calculated field by typing ExpDate: Format([datefield], "yyyy-mm-dd") to convert the date (internally stored as a number) into a text string that MySQL will recognize. You can then export the Query (rather than the table itself). -- John W. Vinson [MVP]
From: Scott_Brasted via AccessMonster.com on 23 Jan 2010 07:41 John, Thank you, I knew it would be easy, but that was even better than easy. I have filed it in my toolkit for sql. It worked a charm. Best, Scott John W. Vinson wrote: >>Greetings, >> >[quoted text clipped - 3 lines] >>change the Access table before I import into mySQL. Does anyone know haw to >>do this? > >You do not need to, nor should you, change the Access table. > >Instead, create a Query based on the table. In that query, don't include the >datefield itself; instead, put in a calculated field by typing > >ExpDate: Format([datefield], "yyyy-mm-dd") > >to convert the date (internally stored as a number) into a text string that >MySQL will recognize. You can then export the Query (rather than the table >itself). -- Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: round to nearest 5 Next: FUNCTION PREDICTING EVEN/ODD COUNT IN QUERY |