[PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Balaji Ankem 

Hi,
 UNIX_TIMESTAMP(2002-03-21 08:30:00) and 
   mktime(2002,03,21,08,30,00) equal or not?

But both are same timestamp..but returning values are
different.y?

 Unixtimestamp from Mysql :1016679600 
 Unixtimestamp from PHP   :953699601 

y this much difference?

Any help would be appreciable.

Thanks in advance
Balaji



**Disclaimer
  


Information contained in this E-MAIL being proprietary to Wipro Limited
is 'privileged' and 'confidential' and intended for use only by the
individual or entity to which it is addressed. You are notified that any
use, copying or dissemination of the information contained in the E-MAIL
in any manner whatsoever is strictly prohibited.



 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Jon Haworth 

 Unixtimestamp from Mysql :1016679600 
 Unixtimestamp from PHP   :953699601 
 y this much difference?

A PHP timestamp is the number of seconds since 1st Jan 1970

A MySQL UNIX_TIMESTAMP is the date in MMDDHHMMSS format.

Cheers
Jon

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Rasmus Lerdorf 

UNIX_TIMESTAMP(2002-03-21 08:30:00) and
mktime(2002,03,21,08,30,00) equal or not?

Careful, 08 != 8

A leading 0 indicates an octal number in PHP.

Also, you have the arguments to mktime() completely messed up.  It is
hour, minute, second, month, day, year.  2002 is a strange-looking hour.

-Rasmus


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Jason Wong 

On Thursday 14 March 2002 18:03, Balaji Ankem wrote:
 Hi,
UNIX_TIMESTAMP(2002-03-21 08:30:00) and
mktime(2002,03,21,08,30,00) equal or not?

   But both are same timestamp..but returning values are
 different.y?

  Unixtimestamp from Mysql :1016679600
  Unixtimestamp from PHP   :953699601

   y this much difference?

The arguments you're giving to mktime are in the wrong order.

mktime (hour, minute, second, month, day, year [, is_dst]);


-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk

/*
186,282 miles per second:
It isn't just a good idea, it's the law!
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Jason Wong 

On Thursday 14 March 2002 18:11, Jon Haworth wrote:
  Unixtimestamp from Mysql :1016679600
  Unixtimestamp from PHP   :953699601
  y this much difference?

 A PHP timestamp is the number of seconds since 1st Jan 1970

To be pedantic, in PHP it is time()

 A MySQL UNIX_TIMESTAMP is the date in MMDDHHMMSS format.

Not correct. In MySQL UNIX_TIMESTAMP also returns the number of seconds since 
the unix epoch.

Thus:

php   -- time();
mysql -- select UNIX_TIMESTAMP();

should both return the same value;


-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk

/*
In the next world, you're on your own.
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php