Isn't DATEDIFF() a MySQL 4.x function? The server I'm using has 3.x and I
can't upgrade...
- Original Message -
From: "Jasper Bryant-Greene" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 29, 2005 7:49 AM
Subject: Re: [PHP] Re: date problem
Mario
Mario netMines wrote:
> Hi Jasper and thanks for the quick reply.
>
> something tells me it's not a straightforward SQL query that I have to
> use here but a logic using PHP and SQL.
Please don't top-post.
It can be done in SQL quite easily, as can many things people use PHP
for. Go to the MySQL
Hi Jasper and thanks for the quick reply.
something tells me it's not a straightforward SQL query that I have to use
here but a logic using PHP and SQL.
Mario
- Original Message -
From: "Jasper Bryant-Greene" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 29, 2005 4:28 AM
Subject: [P
>From the documentation:
http://ca2.php.net/manual/en/function.mktime.php
"Date with year, month and day equal to zero is considered
illegal (otherwise it what be regarded as 30.11.1999, which
would be strange behavior)."
I think the point here to think about is that the date()
> I store all dates in unix timestamp format. It's the easiest one to
work
> with, and it's easy to do things like "date + three days", because
it's
> just
> a case of adding the right number of seconds to the current stamp.
>
> You don't have to split anything, or get substr()'s of anything...
I store all dates in unix timestamp format. It's the easiest one to work
with, and it's easy to do things like "date + three days", because it's just
a case of adding the right number of seconds to the current stamp.
You don't have to split anything, or get substr()'s of anything... and since
da
6 matches
Mail list logo