Kenneth,
try
SELECT id, DATEDIFF(firstdate, postdate) AS diff FROM
calendar
RTFM!
hope that helps, dan
-Original Message-
From: Kenneth Letendre
[mailto:[EMAIL PROTECTED]
Sent: Saturday, January 31, 2004 1:51 PM
To: [EMAIL PROTECTED]
Subject: Subtracting date fields
Hello,
I'm tr
Matt,
Good point, although he didn't specify what version he
was using so I assumed a newer one. Perhaps a
disclaimer should have been included? Anyways,
Kenneth, if you're using an older version try this:
SELECT id, TO_DAYS(firstdate) - TO_DAYS(postdate) AS
diff FROM calendar
Dan
-Original
Try %Y instead of %X
-Original Message-
From: PAUL MENARD [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:08 AM
To: [EMAIL PROTECTED]
Subject: Issue with DATE_FORMAT() call returning wrong
year
Hello all,
I have a query that for some reason is now returning
the incorrect ye
www.soniccommerce.com
They're awesome, all linux, and expect you to grow
over time so they make upgrading your plan simple. i
really love 'em. how often do you hear that about an
ISP?
-dan
-Original Message-
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 8:10 A
What?!?! That wasn't called for. I am in no way
affiliated with them and do not stand to gain anything
if anyone would choose to host with them. I've worked
with over a dozen ISPs and SonicCommerce is my
favorite. That's it, plain and simple.
-Original Message-
From: Jeremy Weaver
[mailto
I would like to do the following:
INSERT INTO tt (a,i) VALUES ('text',MAX(i)+1);
This doesn't work b/c MAX() isn't allowed here. Does
anyone know how I can still achieve this with ONE
query?
Thanks.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
So should we always use InnoDB over BerkeleyBD? I was
under the impression Berkeley was faster and better at
handling transactions.
Dan
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 11:01 AM
To: [EMAIL PROTECTED]
Subject: Re: Memory Pr
Arithmetic results in a value of zero but mysql is
treating the value as > 0. This is reproducible in a
lot of different ways. Below is a pretty clear
example.
mysql> select version();
+---+
| version() |
+---+
| 4.0.17-max-nt |
+---+
1 row in set (0.00 sec)
I would like to do the following:
mysqldump -w "users.user_id=enews.user_id" sotx users
> c:/enews_users.sql
Ideally this would dump all records in table users
where the user_id field value is also present in the
enews table. Is this possible?
TIA,
Dan
--
MySQL General Mailing List
For list a
I've tried about 20 different variations with no luck
except when i modify the where statement to use only
one table. Then it works fine but it's not the results
i want. I was suspecting exactly what you said: you
can only refer to one table, and the first one you
specify at that. I was trying to a
10 matches
Mail list logo
