RE: How to insert time and date into mysql?

I have an application that serializes uploaded files by datetime of upload. This may not be the most efficient, but this will yield a MySQL DATETIME type string: $datetime = date("YmdHis"); If you are looking for a DATE column and a TIME column seperately (not recomended . . . use logic to parse the TIME and DATE parts of a DATETIME column) thet you will need to use $myDate = date("Ymd"); //year,month,day with preceeding zeros $myTime = date("His"); //hours,minutes,seconds with preceeding zeros I have not checked the documentation for these: check the DATE and TIME column type requirements in MySQL, and the date() function in PHP. Obviously, make sure your MySQL column data type is DATETIME, and that you single quote the $datetime value since it's considered text. Here is my SQL string: $sql="INSERT INTO $docMaster ( sqDocID, sqUID, sqSubmitDate, sqDocAnon, sqRequestID, sqHostID, sqTitle, sqCopies, sqOptionStr, sqFileName, sqDocType, Fsize, ppFsize ) VALUES ( NULL, $uid, '$datetime', '$Anon', '$request_id', $sqHostID, '$title', $copies, '$option_list', '$file', '$DocType', $Fsize, $tmpFsize )"; It should be obvious by now that I am making a PHP4/CGI shell script LP print filter. This filter intercepts incoming print streams, then converts postscript to PDF or compresses PCL, moves the result to a controlled directory structure, and then logs to database. A little Apache with PHP with MySQL later, and I have a hands-off paperless queueing system. I love OpenSource! Any interest from the PHP community in seeing this effort released? I'm developing on Solaris for production use on Solaris, and have noted some incompatabilities with Linux, FWIW. John T. Foley Network Administrator Pollak Engineered Products, Actuator Products Division, A Stoneridge Company 195 Freeport Street, Boston MA 02122 ph: (617) 474-7266 fax: (617) 282-9058 The geographical center of Boston is in Roxbury. Due north of the center we find the South End. This is not to be confused with South Boston which lies directly east from the South End. North of the South End is East Boston and southwest of East Boston is the North End. > -----Original Message----- > From: Zenith [SMTP:zenith@linuxmail.org] > Sent: Monday, February 28, 2000 1:16 PM > To: php-general@lists.php.net > Subject: How to insert time and date into mysql? > > How can I insert time and date into mysql table, > if the table i have to insert has a field of type time, and a field of > type > date. > > Then how can I insert it in PHP, if I use time() function?? > >