Access97 Compare two Dates
up vote
-2
down vote
favorite
I'm trying to compare 2 dates with an SQL Query,
My query is this :
"SELECT table.toto
FROM table
WHERE
table.date < $date"
$date
is a variable that comes from my PHP code
In my table, my date is formatted like this : dd/mm/YYYY
Unfortunately, it doesn't work as expected, it returns only one result (it's supposed to return way more results), which date is : 1312-09-15 00:00:00
but in database, the date is formatted like dd/mm/YYYY.
php sql date
add a comment |
up vote
-2
down vote
favorite
I'm trying to compare 2 dates with an SQL Query,
My query is this :
"SELECT table.toto
FROM table
WHERE
table.date < $date"
$date
is a variable that comes from my PHP code
In my table, my date is formatted like this : dd/mm/YYYY
Unfortunately, it doesn't work as expected, it returns only one result (it's supposed to return way more results), which date is : 1312-09-15 00:00:00
but in database, the date is formatted like dd/mm/YYYY.
php sql date
add a comment |
up vote
-2
down vote
favorite
up vote
-2
down vote
favorite
I'm trying to compare 2 dates with an SQL Query,
My query is this :
"SELECT table.toto
FROM table
WHERE
table.date < $date"
$date
is a variable that comes from my PHP code
In my table, my date is formatted like this : dd/mm/YYYY
Unfortunately, it doesn't work as expected, it returns only one result (it's supposed to return way more results), which date is : 1312-09-15 00:00:00
but in database, the date is formatted like dd/mm/YYYY.
php sql date
I'm trying to compare 2 dates with an SQL Query,
My query is this :
"SELECT table.toto
FROM table
WHERE
table.date < $date"
$date
is a variable that comes from my PHP code
In my table, my date is formatted like this : dd/mm/YYYY
Unfortunately, it doesn't work as expected, it returns only one result (it's supposed to return way more results), which date is : 1312-09-15 00:00:00
but in database, the date is formatted like dd/mm/YYYY.
php sql date
php sql date
edited Nov 21 at 15:47
Gustav
28.9k51734
28.9k51734
asked Nov 21 at 13:36
A.Vinuela
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Well, I found a solution to my problem.
I don't know why but I just have set the "$date" format to : n/d/Y
and to wrap it between "#" in code like this :
"SELECT table.toto
FROM table
WHERE
table.date < #date#"
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Well, I found a solution to my problem.
I don't know why but I just have set the "$date" format to : n/d/Y
and to wrap it between "#" in code like this :
"SELECT table.toto
FROM table
WHERE
table.date < #date#"
add a comment |
up vote
0
down vote
Well, I found a solution to my problem.
I don't know why but I just have set the "$date" format to : n/d/Y
and to wrap it between "#" in code like this :
"SELECT table.toto
FROM table
WHERE
table.date < #date#"
add a comment |
up vote
0
down vote
up vote
0
down vote
Well, I found a solution to my problem.
I don't know why but I just have set the "$date" format to : n/d/Y
and to wrap it between "#" in code like this :
"SELECT table.toto
FROM table
WHERE
table.date < #date#"
Well, I found a solution to my problem.
I don't know why but I just have set the "$date" format to : n/d/Y
and to wrap it between "#" in code like this :
"SELECT table.toto
FROM table
WHERE
table.date < #date#"
edited Nov 21 at 14:07
WhatsThePoint
2,11342034
2,11342034
answered Nov 21 at 14:01
A.Vinuela
1
1
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413285%2faccess97-compare-two-dates%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown