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 unsubscribe:http
;
***
I can't seem to work out a way of doing that 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
, 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 unsubscribe:http://lists.mysql.com
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 = SELECT ..
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
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 gave
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
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 -
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) |
+---+
|
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
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 mysqlbug
: 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
UNIX_TIMESTAMP).
Mayb
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 =(
I am using version 3.22.32
, 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 some of the data - e.g the first 500 rows of the 'order
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-03-01 |
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 record in
: 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)
| 0120472 | 2001-03-01 |
| 0120471 | 2001-03-01
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;
+---+-+
| member_id | signup_date
19 matches
Mail list logo