Re: query, INTERVAL problem
| From: | Becoming Digital | Date: | Tue, 27 May 2003 11:32:47 +0000 |
| Subject: | Re: query, INTERVAL problem | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28083@lists.php.net to get a copy of this message | ||
> when I send $due_date as '20030501' the query return a different than
> '2003-05-01'
As Jason said initially, you can't expect the database to magically transform
the $due_date into DATE format. You need to process the string before you try
to work with it in SQL.
$due_date = strtotime( $due_date );
$due_date = date( "Y-m-d", $due_date );
Edward Dudlik
Becoming Digital
www.becomingdigital.com
----- Original Message -----
From: "nabil" <nabil.attar@aws-syria.com>
To: <php-db@lists.php.net>
Sent: Tuesday, 27 May, 2003 05:03
Subject: Re: [PHP-DB] query, INTERVAL problem
No Jason, what I meant that I submit the date value from a form to MySQL, to
execute a query as I said below, and it returns deferent value for that ...
when I send $due_date as '20030501' the query return a different than
'2003-05-01'
Hope I make clear..
"Jason Wong" <php-db@gremlins.biz> wrote in message
news:200305271511.22393.php-db@gremlins.biz...
> On Tuesday 27 May 2003 14:23, nabil wrote:
> > I have many problem when I submit (from form) the $due_date , so when I
> > send it as '20030501' it returns with deferent result than
> > '2003-05-01'
and
>
> It's not clear what you mean.
>
> Are you saying: you enter '20030501' into the form and you expect it to
come
> out as '2003-05-01'? If so this is not going to happen, what you enter is
> what you get, the values don't magically transform themselves without
further
> work on your part.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> ------------------------------------------
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-db
> ------------------------------------------
> /*
> In Hollywood, all marriages are happy. It's trying to live together
> afterwards that causes the problems.
> -- Shelley Winters
> */
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php