On 13 Jul 2006 at 8:27, wizard007 wrote:
> I used $query_Recordset1 = "SELECT date_format(Date, "%d/%m/%Y") as Date,
> Course, Time, Horse, Odds1, Odds2, `Result` FROM Results";
Hi,
That's a PHP error because you have a double quotes: "%d/%m/%Y" within double
quotes: $query_Recordset1 = "SELEC
ourse, Time, Horse, Odds1, Odds2, `Result` FROM Results";
--
View this message in context:
http://www.nabble.com/Date-Problems-tf1937078.html#a5310495
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Date from table where
datediff(date_format(now(),\"%Y-%m-%d
%H:%i:%s\"),date_format(Date,\"%Y-%m-%d %H:%i:%s\"))<=7
order by Date desc;
***
> I can't seem to work out a way of doing that either.
>
> I'm a newb so please be gentle! :-)
>
>
&
either.
I'm a newb so please be gentle! :-)
--
View this message in context:
http://www.nabble.com/Date-Problems-tf1937078.html#a5307385
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 7 Aug 2003 at 15:27, Andy Jackman wrote:
> 1) I was investigating the unix_timestamp routine in mysql (version
> 3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned
> with a value of -3600.
That's what I'd expect if the time zone was set to -0100, since
MySQL assumes the str
On 7 Aug 2003 at 16:12, Andy Jackman wrote:
> >> or is there some summertime adjustment occurring?
> You're right the -3600 looks like 1 hour of summertime and our server
> IS set to BST (1 hour ahead of GMT - sorry I can never figure out if
> that is -0100 or +0100). However, the same function ga
Hi,
1) I was investigating the unix_timestamp routine in mysql (version
3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned
with a value of -3600. Then, as you can see, it suddenly corrected
itself. I can't replicate this error, but it caused me to shudder.
Attached is the output
Keith,
>> or is there some summertime adjustment occurring?
You're right the -3600 looks like 1 hour of summertime and our server IS
set to BST (1 hour ahead of GMT - sorry I can never figure out if that
is -0100 or +0100). However, the same function gave different results a
few minutes apart - tha
On 7 Aug 2003 at 9:47, woody at nfri dot com wrote:
> While I don't know for sure, my guess is that it would have something
> to do with 32 bit as the magic number, but also...being that this
> won't become a problem until
>
> mysql> select from_unixtime(2147483647);
> +-
While I don't know for sure, my guess is that it would have something to
do with 32 bit as the magic number, but also...being that this won't
become a problem until
mysql> select from_unixtime(2147483647);
+---+
| from_unixtime(2147483647) |
+---+
|
Since I
didn't use the update_log, all data from today is gone. Live and learn.
Thanks for all your help!
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:58 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more d
entin Bennett; [EMAIL PROTECTED]
Subject: RE: more date problems
On Thu, 1 Mar 2001, Daren Cotter wrote:
> Ok, here goes...
>
> mysql> select member_id, signup_date from members order by member_id desc
> limit 410;
> +---+-+
>
Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Ok, here goes...
mysql> select member_id, signup_date from members order by member_id desc
limit 410;
+---+-+
| member_id | signup_date |
+---+-+
(here's the last 20 or so rows)
|
On Thu, 1 Mar 2001 19:32:54 -0800, "Daren Cotter" <[EMAIL PROTECTED]>
wrote:
>>So, the question is, why does this not return 400, like it should???
>>
>>OK, weird! Now I am getting this error...
>>
>>mysql> select count(*) from members where signup_date = '2001-03-01';
>>ERROR 1032: Can't find re
On Thu, 1 Mar 2001, Daren Cotter wrote:
> Ok, here goes...
>
> mysql> select member_id, signup_date from members order by member_id desc
> limit 410;
> +---+-+
> | member_id | signup_date |
> +---+-+
> (here's the last 20 or so rows)
> | 0120472 | 2001-0
e checked the tables using the checking utility, they show up fine.
What's going on? =)
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:45 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Can you post s
age-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 March 2001 3:34 p.m.
To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Quentin,
that does not work either, I still get the 125 number, when there are
actually 500 records
D]
Subject: RE: more date problems
Hi,
Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that
gives.
Also, what version are you on - I have had some date problems where the end
of one month and the begining of another get confused (usually when doing a
Hi,
Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that
gives.
Also, what version are you on - I have had some date problems where the end
of one month and the begining of another get confused (usually when doing a
UNIX_TIMESTAMP).
Maybe then use
okay, this is a follow-up to my past email...
since I KNOW more than 122 people have signed up today, I did the following
query:
SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit
200;
there are at LEAST 200 people that have signed up today. however, when i do:
SELECT cou
20 matches
Mail list logo
