Why not use the CURDATE() and CURTIME() functions built into mysql?
Kevin Cawthorne
----- Original Message -----
From: "Foley, John" <[EMAIL PROTECTED]>
To: "'Zenith'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 2:20 PM
Subject: [PHP] 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"); file://year,month,day with preceeding zeros
> $myTime = date("His"); file://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:[EMAIL PROTECTED]]
> > Sent: Monday, February 28, 2000 1:16 PM
> > To: [EMAIL PROTECTED]
> > 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??
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
