I am sorry, the instruction I sent doesn't work in MySQL: You should use: INSERT INTO your_table (field1, field2, field3) VALUES(CURDATE(), "value2", CURTIME()) Note the CUR (I think it stands for CURrent)
Thanks Emery ----- Original Message ----- From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "Emilio Ruben Estevez" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 02, 2003 22:16 Subject: Re: How can i make mysql to print date and time automatically? > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]