On Thursday 14 March 2002 17:38, Balaji Ankem wrote:
[snip]
> $sql1="select UNIX_TIMESTAMP('start_date')
> startdate,UNIX_TIMESTAMP('end_date') enddate from request where
> req_status='Approved'";
Did you try entering this query ($sql1) into mysql at the command line to
ensure that it's valid and returns some results?
> I am getting values printed is 0.
>
> Actually UNIX_TIMESTAMP(2001:03:21 10:45:00) means what?
> What it returns?
UNIX_TIMESTAMP returns the number of seconds between the unix epoch
(1970-01-01 00:00:00) and the date.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
A certain amount of opposition is a help, not a hindrance. Kites rise
against the wind, not with it.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
