On Thursday 14 March 2002 17:38, Balaji Ankem wrote:


>               $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

Reply via email to