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
- 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 of bands appearing at a club. I
- 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 of bands appearing at a club. I
Hi Karl-
I often use a unix timestamp value for my dates (an unsigned mediumint is
adequate) and index that. However, using date/time functions in the where
clause does have a significant impact on the execution times, even when the
index is used and the EXPLAIN output appears the same. See examp
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
Try something like SELECT formatted_date FROM mytable WHERE
formatted_date BETWEEN '04-08-2003' and '07-08-2003';
Or something along those lines, I would get more specific but I do not
have specific information to go from.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: P
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.
>
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
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
19 matches
Mail list logo
