List:General Discussion« Previous MessageNext Message »
From:Gordon Date:March 8 2005 1:28pm
Subject:RE: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');
View as plain text  
I have > 200 tables with regular datetime fields. I link these tables
through ODBC to an ACCESS database where I can run standard ACCESS append
queries or even copy/paste append into the linked table. ODBC handles the
conversion just fine. 

One caution, MySQL timestamp maps to ACCESS datetime but ACCESS datetime
does not map to MySQL timestamp. 

We are on ODBC 3.51.nn and MySQL 4.0.20, but we have been doing this across
several versions for 3 years.

-----Original Message-----
From: Scott Hamm [mailto:linuxgold@stripped] 
Sent: Friday, March 04, 2005 9:08 AM
To: Mysql
Subject: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');

How do I create a table using:

date_format('2004-10-03 15:06:14','%m/%d/%y %T');

That way I can import Access Data?
-- 
Power to people, Linux is here.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
select date_format('2004-10-03 15:06:14','%m/%d/%y %T');Scott Hamm4 Mar
  • Re: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');Daniel Kasak6 Mar
    • Re: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');Scott Hamm7 Mar
  • RE: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');Gordon8 Mar
RE: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');Michael Stembridge9 Mar