INSERT INTO your_table (field1, field2, field3) VALUES(DATE(), "value2", TIME())
But check the manual for very simple things. Thanks Emery ----- Original Message ----- From: "Emilio Ruben Estevez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 17:09 Subject: How can i make mysql to print date and time automatically? > Hi, im develping an application, and was wondering how can i make mysql get > time and date from pc and print it automatically in the time field and date > field so the user dont have to worry about entering the coorect time and > date. Is this posible, ive created a databse with fields hour(time) and > Date(date) like type but i dont know how to do the mysql to get time and > date and print it! > > Any hints? > > Thaks in advance. > Emilio. > > _________________________________________________________________ > Add MSN 8 Internet Software to your existing Internet access and enjoy > patented spam protection and more. Sign up now! > http://join.msn.com/?page=dept/byoa > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]