DBD/DBI datetime insert

2006-09-03 Thread Hal Wigoda
anyone have the code that will insert the current time into a datetime field in a table while using perl DBI/DBD::mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DBD/DBI datetime insert

2006-09-03 Thread Paul DuBois
At 7:23 PM -0500 9/3/06, Hal Wigoda wrote: anyone have the code that will insert the current time into a datetime field in a table while using perl DBI/DBD::mysql? Something like this: $dbh-do(INSERT INTO t (col_name) VALUES(NOW())); -- Paul DuBois, MySQL Documentation Team Madison,

Re: DBD/DBI datetime insert

2006-09-03 Thread Hal Wigoda
that looks very good. On Sep 3, 2006, at 7:26 PM, Paul DuBois wrote: At 7:23 PM -0500 9/3/06, Hal Wigoda wrote: anyone have the code that will insert the current time into a datetime field in a table while using perl DBI/DBD::mysql? Something like this: $dbh-do(INSERT INTO t (col_name)