Hi Christian,
Christian High wrote:
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday. I need to develop a
query that will subtract the scale reading on one d
On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Christian High wrote:
> > On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> >> Hi,
> >>
> >> Christian High wrote:
> >>> I have a table that includes a date and a scale reading like
> >>>
> >>> datescale_reading
>
Hi,
Christian High wrote:
On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Christian High wrote:
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday.
On Aug 14, 2007, at 8:38 AM, Christian High wrote:
On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Christian High wrote:
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or m
On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Christian High wrote:
> > I have a table that includes a date and a scale reading like
> >
> > datescale_reading
> > 2007-08-01 150
> > 2007-08-02 125
> >
> > these reading may or may not be taken everyday.
Hi,
Christian High wrote:
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday. I need to develop a
query that will subtract the scale reading on one day from the
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday. I need to develop a
query that will subtract the scale reading on one day from the scale
reading on the next m
X: 860.674.8341
> -Original Message-
> From: Joey [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 31, 2007 4:18 AM
> To: 'Jerry Schwartz'
> Subject: RE: Help With a Week ( date ) query
>
> Hi Jerry,
> This part of the query is working, but something
-Original Message-
>> From: Joey [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, March 29, 2007 9:46 AM
>> To: MySQL DB
>> Subject: Help With a Week ( date ) query
>>
>> Hi Guys,
>>
>> I'm kind of at a standstill in coming up with how to get
mington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Joey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 29, 2007 9:46 AM
> To: MySQL DB
> Subject: Help With a Week ( date ) query
>
> Hi Guys,
>
> I'm kind of a
Hi Guys,
I'm kind of at a standstill in coming up with how to get a query I need to
write.
I'm trying to find a record which matches the week we are in.
Example today is Thursday the 29th, it is within the week which has the 26th
through the 1st, and if the day is within this week display the reco
I'm not sure if there is a built-in, but what I usually do
for similar things is to use general purpose table to force
iteration.
E.g. create a table called ITERATE with one column, x, and
populate with values 0,1,2,3,4,... -- in your case up to 10
-- and index the column.
Then it's easy - I only s
Hi,
I have a table called Bookings which holds start times and end times for
appointments, these are held in Booking_Start_Date and Booking_End_Date. I
have a page on my site that runs a query to produce a grid to show
availiability per day for the next ten days for each user of the system.
Use
Jack Lauman <[EMAIL PROTECTED]> wrote on 02/04/2005 11:57:37 AM:
> I want to run a nightly cron job where you iterate throught each row of
> a single table and reset a field depending on the conditions specified.
> In this case I want to take a date field (RenewalDate) and compare it
> to the
I want to run a nightly cron job where you iterate throught each row of
a single table and reset a field depending on the conditions specified.
In this case I want to take a date field (RenewalDate) and compare it
to the current date less a 30 day grace period and if true reset the
(Subscripti
On Tuesday 07 December 2004 02:51 pm, you wrote:
> mysql> explain select * from queryLog where date_format(queryTime,
> '%Y-%m-%d') =
> '2004-11-16';
> mysql> explain select * from queryLog where queryTime =
> date_format('2004-11-16'
> , '%Y-%m-%d');
> +--+--+---+---
mysql> explain select * from queryLog where date_format(queryTime,
'%Y-%m-%d') =
'2004-11-16';
+--+--+---+--+-+--+--+-+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
+--+--+---+--
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
> A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will kill an
index.
Jeff
pgpsVFJcgS9kp.pgp
Description: PGP signature
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 11:34 AM
To: [EMAIL PROTECTED]
Subject: slow date query
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12
--
From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 12:05 PM
To: Marc Dumontier; [EMAIL PROTECTED]
Subject: RE: slow date query
Well 1st of all Date_format doesn't allow the use of a key.
Do this.
SELECT ..
WHERE DateLastRevised >= '2004-12-07' A
er 07, 2004 11:34 AM
To: [EMAIL PROTECTED]
Subject: slow date query
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows
A function on the left hand side will nullify the use of an index.
Marc Dumontier wrote:
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows, t
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows, this query takes very long, in the
neighbourhood of 20 minutes.
i'm using mysqld 4.0.20.
- Original Message -
From: "darrell troth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 3:29 PM
Subject: Date query and date removal
> This will seem an easy question, but I cannot find a sample anywhere:
> I have a database
- Original Message -
From: "darrell troth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 3:29 PM
Subject: Date query and date removal
> This will seem an easy question, but I cannot find a sample anywhere:
> I have a database
This will seem an easy question, but I cannot find a sample anywhere:
I have a database of bands appearing at a club. I want to update the list
sorted by date and have the results only show current date and beyond (i.e. -
remove band that played last night from results page). This query is drivin
On Tue, 7 Sep 2004, Lee Denny wrote:
> Hello,
>
> I need to perform a select that compares two dates
>
> I need to return all records that haven't had date_2 set after a given
> number of days since date_1.
>
... WHERE date_2 < date_1 + INTERVAL X DAY
Where X is the number of days.
Assuming th
If I understand you correctly, I think you want rows with date_2 not greater
than or equal to date_1 plus some number of days, say 30. Then date_2 needs
to be less than date_1 plus 30 days. So, you would use something like:
SELECT * FROM yourtable
WHERE date_2 < date_1 + INTERVAL 30 DAY;
T
Hello,
I need to perform a select that compares two dates
I need to return all records that haven't had date_2 set after a given
number of days since date_1.
I'm sure this can be done in one query but I just can't get my head around
this one.
Can anyone help?
Cheers,
Lee
--
MySQL General M
Michael,
Michael Stassen wrote:
Mike Blezien wrote:
Hello,
Not sure this is possible to do with SQL or if needs to be done with
in the application programming language we're using(Perl), but I need
to get the a weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to
Mike Blezien wrote:
Hello,
Not sure this is possible to do with SQL or if needs to be done with in
the application programming language we're using(Perl), but I need to
get the a weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to do, is if the query above is gre
Hello,
Not sure this is possible to do with SQL or if needs to be done with in the
application programming language we're using(Perl), but I need to get the a
weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to do, is if the query above is greater or less then 15
I believe you are not letting MySQL do enough work for you. The date
format is perfect, even as a string, to perform the comparison you are
trying to perform.
SELECT @currTime := NOW();
+-+
| @currTime := NOW() |
+-+
| 2004-08-26 12:48:16 |
+
On Thu, 26 Aug 2004 11:31:46 -0500, Yong Wang <[EMAIL PROTECTED]> wrote:
>
> I have a database which contains date attribute in string format
> (like 2004-08-12). I want to genearte a report based on period time.
> I use the syntax:
> date1 ='2004-08-12'
> date2='2004-08-18'
> SELECT * FROM ac
Hi, All:
I have a database which contains date attribute in string format
(like 2004-08-12). I want to genearte a report based on period time.
I use the syntax:
date1 ='2004-08-12'
date2='2004-08-18'
SELECT * FROM account WHERE (TO_DAYS(date) >= TODAYS(date1)) and
(TO_DAYS(date) <= TO_DAYS(date
|
| To: [EMAIL PROTECTED]
|
| cc:
Hi,
I have a table called Bookings which holds start times and end times for
appointments, these are held in Booking_Start_Date and Booking_End_Date. I
have a page on my site that runs a query to produce a grid to show
availiability per day for the next ten days for each user of the system.
Use
Fantastic! This was indeed the problem and has solved it. Many thanks!
On Tue, 24 Feb 2004 13:14:51 +0100, Jigal van Hemert wrote:
>> $sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
>> WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
>> and \'$Date2\
> $sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
> WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
> and \'$Date2\' GROUP BY Username';
>
> The strange thing is if I replace the $Date2 variable with a date manually
> it works -. i.e.
Not a MySQL issu
Hello All,
I have a very strange problem which makes no sense to me whatsoever.
I am trying to find the number of queries that the people have dealt with
in a database between two dates. The dates are generated from some drop
down boxes and dropped into a variable. This is the code for the query.
I don't have much experience working with dates in Mysql; I've always
prefered to manage dates in code, so bear with me.
I've got the following definition (yes, no indexes right now):
CREATE TABLE se_t (
datestamp timestamp(14) NOT NULL,
remote_addr char(16) NOT NULL default '',
request_ur
Hi,This query is give an error like below;There is
a column that name and description are date in Table that also include
database.in the table,there are some date like
that:2003-12-01,2003-11-16,2003-12-01,2003-12-03,2003-11-19. when i run this
query,if i query between 2003-12-01 and 2003-12
te a report
o i fogot to tell you i had a date field in every table
im not sure if this is what you r actually looking for
but i hope this helps you .
good luck
toby
From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject:
erve a vacation!
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:00 PM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Unusual Date Query
At 12:59 PM 10/10/2003, you wrote:
>I want know if there is a way to return every date betwe
At 12:59 PM 10/10/2003, you wrote:
I want know if there is a way to return every date between 2 date ranges
regardless if there is a row in a table. I have a table that contains
daily pricing information and I want to be able to do a mass
updated/insert records. I know how to write the updates/in
I want know if there is a way to return every date between 2 date ranges
regardless if there is a row in a table. I have a table that contains
daily pricing information and I want to be able to do a mass
updated/insert records. I know how to write the updates/inserts if I
have table that contains
* Jack Lauman
> I have a table with a column "date" that contains dates in SQL format,
> i.e. 2003-08-10
>
> I need to query the table and return all the rows from the current date
> thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
>
> I have tried the following query which
I have a table with a column "date" that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns all of the desired
utious using functions in your where
clause - you might get surprised.
Best of luck,
Rick
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 12:25 PM
To: [EMAIL PROTECTED]
Subject: Date query optimization
Hi folks,
I do a considerable amount o
On 1 Jul 2003 at 10:28, Karl J. Stubsjoen wrote:
> > The normal way to do a search for a range of dates would be
> >
> >... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14';
> >
> > Is that what you're looking for?
>
> submitdate happens to be a DATETIME field.
> Your suggested query
Keith,
> The normal way to do a search for a range of dates would be
>
>... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14';
>
> Is that what you're looking for?
submitdate happens to be a DATETIME field.
Your suggested query doesn't pull any results. Must I convert the field
first?
On 1 Jul 2003 at 9:25, Karl J. Stubsjoen wrote:
> ROWS: 34,000 + searched
> explain
> select
> a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.sta
> te,a.z
> ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.su
> bmitte dby from submit as a inner join re_idx as
Hi folks,
I do a considerable amount of queries based on a date, and or date range. I
have not had much luck with optimizing these queries. In some cases I use a
date field and others a datetime field.
The following query searches through 34,000 + records, while specifiying the
exact date searche
al Message-
From: Prashant Akerkar [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 4:27 AM
To: [EMAIL PROTECTED]; Karam Chand; [EMAIL PROTECTED]; Donald
Longan; miguel solorzano; [EMAIL PROTECTED]
Subject: Date Query
Dear Friends
I have a Query regarding Displaying Dates
I have two fie
- Original Message -
From: Prashant Akerkar
To: [EMAIL PROTECTED] ; Karam Chand ; [EMAIL PROTECTED] ; Donald Longan ; miguel
solorzano ; [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 3:56 PM
Subject: Date Query
- Original Message -
From: Prashant Akerkar <[EMAIL PROTEC
- Original Message -
From: Prashant Akerkar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 3:23 PM
Subject: Date Query
Dear Friends
I have a Query regarding Displaying Dates
I have two field in my mysql Table for Date_from and Date_To
Retrived rec
- Original Message -
From: Alexander Keremidarski <[EMAIL PROTECTED]>
To: Prashant Akerkar <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 3:32 PM
Subject: Re: Date Query
> Hello,
>
> Prashant Akerkar wrote:
> > Dear Friends
>
- Original Message -
From: Alexander Keremidarski <[EMAIL PROTECTED]>
To: Prashant Akerkar <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 3:32 PM
Subject: Re: Date Query
> Hello,
>
> Prashant Akerkar wrote:
> > Dear Friends
>
Thanks..that helped.
anil :)
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 10:52 AM
To: [EMAIL PROTECTED]
Cc: Anil Garg
Subject: Re: date query.
* Anil Garg
> The date field in my database table looks as below:
> 07th of March 2003
At 09:36 AM 3/10/2003, Anil Garg wrote:
The date field in my database table looks as below:
"07th of March 2003 10:14:29 PM"
Weird. All of my datetime variables look like '2003-03-07 22:14:29'. Are
these fields datetime field types or are they text that looks like a date?
If they are datetime,
* Anil Garg
> The date field in my database table looks as below:
> 07th of March 2003 10:14:29 PM
Then it is probably not a 'date field' in the sense that it is of type
"date", "datetime" or "timestamp".
> I need to write a query which gets me all the rows which are
> entered in last to weeks.
>
Hi,
The date field in my database table looks as below:
07th of March 2003 10:14:29 PM
I need to write a query which gets me all the rows which are entered in last
to weeks.
Any ideas!!
Thanks and Regards
Anil.
-
Before posti
From: "Erick Hitter" <[EMAIL PROTECTED]>
> Hello,
> I run the web site for a band, and I am currently working on the
> shows list for the band. I have all of the shows listed in a database
> right now. I don't want to remove the shows that occurred in the past,
> but instead I want to have a quer
Hello,
I run the web site for a band, and I am currently working on the shows list
for the band. I have all of the shows listed in a database right now. I
don't want to remove the shows that occurred in the past, but instead I want
to have a query find only the shows that occur in the future. I ha
select abc AS date from mytables;
Simon
-Original Message-
From: Alec Smith [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 09:30
To: Don Read
Cc: [EMAIL PROTECTED]
Subject: RE: Proper date query conversion structure?
Ok, dumb mistake... Remind me not to code so late at night. :)
With
Ok, dumb mistake... Remind me not to code so late at night. :)
With that fixed, I now get
mysql> select DATE_FORMAT(post_timestamp, '%M %d, %Y') from guestbook;
+--+
| DATE_FORMAT(post_timestamp, '%M %d, %Y') |
+--+
On 04-Jun-01 Alec Smith wrote:
> What would be the correct query to convert a date stored in MySQL in
> a
> DATETIME field to month_name month_date, year format at the same time
> I'm
> pulling a bunch of other data from the same row as the field with the
> date I need converted? I've tried somet
What would be the correct query to convert a date stored in MySQL in a
DATETIME field to month_name month_date, year format at the same time I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something like the below without
success:
SELECT
but is not very nice..
-Original Message-
From: Peter Skipworth [mailto:[EMAIL PROTECTED]]
Sent: donderdag 8 maart 2001 9:43
To: Adams, Antoine A SSI-ISES-56
Cc: '[EMAIL PROTECTED]'
Subject: Re: Date query problem (hard one)
Antione,
What's your definition of a week number
Antione,
What's your definition of a week number ? A week number in the range
1..52 is not in itself enough to calculate a precise date from..
regards,
P
On Thu, 8
Mar 2001, Adams, Antoine A SSI-ISES-56 wrote:
> I've been strugling with a query for some time now and I can't get the
> desired
I've been strugling with a query for some time now and I can't get the
desired answer from mysql.
The desired answer: a date (bv. 2001-02-08)
What is the input: a week number
What date do I need: The date of the monday where week = x
the idea was: select date(week(10),1);
But offcourse th
71 matches
Mail list logo
