Re: Hi what is the prob with this small file?
| From: | Jason Wong | Date: | Thu, 14 Mar 2002 10:51:05 +0000 |
| Subject: | Re: Hi what is the prob with this small file? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-88464@lists.php.net to get a copy of this message | ||
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.
*/