I am uploading data into a MySql table from a VB application. I want to get today's date using Date. When I look at the results, what is 3/8/2004 in my VB app, is now 2003-08-20. I am guessing this is a formatting problem. Any ideas?
when you give mysql a date, it must be in year-month-day sequence
you could upload your dates into a varchar(10) column, alter the table to add a new column with DATE or DATETIME datatype, then update the table and use substring expressions to pull the pieces out of the varchar column to update the date column