Hi The PHP time() function returns the number of seconds since the Unix epoch (Jan 1 1970 midnight) whereas MySQL uses a readable datestamp See here: http://dev.mysql.com/doc/mysql/en/datetime.html for the MySQL date, time and date/time types and here http://uk.php.net/manual/en/function.time.php for time()... instead of using time(), use date() and format it for MySQL http://uk.php.net/manual/en/function.date.php That will allow you to use < and > in the SQL statements HTH -------- Chrome? http://www.chrome.me.uk -----Original Message----- From: bruce [mailto:bedouglas@xxxxxxxxxxxxx] Sent: 26 September 2005 19:46 To: 'John Nichel'; php-general@xxxxxxxxxxxxx Subject: RE: mysql/php date functions.. john... that appears to be it!! although i would have assumes it would have done a most significant bit fill with 0's... so my question also comes down to .. do i use the php date functions for date/time manipulation.. or do i use the mysql functions.... any thoughts/suggestions... -bruce -----Original Message----- From: John Nichel [mailto:john@xxxxxxxxxxxx] Sent: Monday, September 26, 2005 11:19 AM To: php-general@xxxxxxxxxxxxx Subject: Re: mysql/php date functions.. bruce wrote: > thanks... > > but that's not it john... i'm not worried about creating the sql_statement > in the php... > > i'm concerned that i can't seem to craft/create a basic sql cmd within mysql > to get a value (other than NOW()) to work... > > if i do (from mysql) > -->> insert into foo (id, time) values (2, 333333), it doesn't work... > if i > -->> insert into foo (id, time) values (2, NOW()), it works!!... > > my question is why??? Without knowing the structure of your table, my guess is that the column time is expecting a valid timestamp, and 333333 is not a valid MySQL timestamp. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@xxxxxxxxxxxx -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
