Hi,
I am trying to add a date to mysql, and i am having a
problem.. its seems to add the date fine, but when i
check the table the date is incorrect. here's the
code....

dim tmpdate as date

sqlstr " insert in tb1(date_c) values("'" & tmpdate
&"'"

set rs = new adodb.recordset
rs.activeconnection = connmysql
rs.open sqlstr


a record is added, buth when i view the table, all i
can see is the following has been added each time

20/10/2028 03:00:00


any ideas?

thanks


__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=m...ie.nctu.edu.tw

insert date using this format. If you are using other date format in your
country (like DD.MM.YYYY in Czech or German), you must convert date in your
code first.

Petr Vileta, Czech republic



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=m...ie.nctu.edu.tw