i have a tbl with the following...
foo date1
foo2 date2
etc...
how can i do a select to get the last or 1st row based on the
(latest/earliest) date?
can't seem to get it to work..
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
bruce wrote:
i have a tbl with the following...
foo date1
foo2 date2
etc...
how can i do a select to get the last or 1st row based on the
(latest/earliest) date?
SELECT * FROM tbl order by datecolumn DESC LIMIT 1;
SELECT * FROM tbl order by datecolumn ASC LIMIT 1;
can't seem to get it to work..
AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: date question..
bruce wrote:
i have a tbl with the following...
foo date1
foo2 date2
etc...
how can i do a select to get the last or 1st row based on the
(latest/earliest) date?
SELECT * FROM tbl order by datecolumn DESC LIMIT
/comments
regards,
-bruce
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 11:12 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: date question..
bruce wrote:
i have a tbl with the following...
foo date1
foo2 date2
etc...
how can i
PROTECTED]
Subject: Re: date question..
The manual describes 3 solutions to this problem
http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html.
Michael
bruce wrote:
the earlier suggestion didn't work, as it only returned a single value...
here's the entire issue i have
hi...
i have the following select...
select
itemID,
process,
status,
tblType,
max(date)
from historyTBL
where (tblType = '3' or tblType = '2')
group by tblType;
it seems to work, in that it gives me the rows for the two types that i'm
grouping by.
the problem is that i want the row that
Have you tried this:
select ..., max(date) as mdate from ... where ... group by ... order
by mdate desc ?
I haven't tested it, but it should order the results by max date
descending, giving you the greatest date first.
On Fri, 10 Sep 2004 18:16:00 -0700, bruce [EMAIL PROTECTED] wrote:
hi...
bruce wrote:
hi...
i have the following select...
SELECT itemID, process, status, tblType, MAX(date)
FROM historyTBL
WHERE (tblType = '3' or tblType = '2')
GROUP BY tblType;
it seems to work, in that it gives me the rows for the two types that i'm
grouping by.
the problem is that i want the row
Hi again,
I got the MONTH() selection thing working now, but it seems like I'm not
getting the hang of the concept with the sql date..
With PHP and a UNIX timestamp I would just insert a timestamp, the
select it and after selection, go ahead and manipulate it to fit my
needs, like extracting day
: Monday, May 10, 2004 1:56 PM
Subject: Date Question 2
Hi again,
I got the MONTH() selection thing working now, but it seems like
I'm not
getting the hang of the concept with the sql date..
With PHP and a UNIX timestamp I would just insert a timestamp, the
select it and after selection, go ahead
mysql,
The question is:
If I use unix date Command like: date -date=20030220 +%j
I will get 051 which is Julian date.
I like to know how I can get Julian date if I use mysql or Python.
Thanks.
-
Before posting, please check:
In the last episode (Feb 24), Vivian Wang said:
mysql,
The question is:
If I use unix date Command like: date -date=20030220 +%j
I will get 051 which is Julian date.
I like to know how I can get Julian date if I use mysql or Python.
Mysql's date_format function supports the same escapes
Ed,
Wednesday, May 29, 2002, 2:24:40 AM, you wrote:
EL I'm not sure how to phrase this. Please excuse the crudeness of my description.
EL I'm storing calendar data in a MySQL database and I'm wondering, is there a
EL way to specify a day, such as the 28th, and fourth Tuesday as search
EL
I'm not sure how to phrase this. Please excuse the crudeness of my description.
I'm storing calendar data in a MySQL database and I'm wondering, is there a
way to specify a day, such as the 28th, and fourth Tuesday as search
criteria when selecting rows from a table with a field of type date?
for mysql, if I have a text file that has the date as 5/17/2002, is there a way I can
translate that to mysql's version of the date, i.e. 2002-05-17?
With Load Data as well?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
hi,
I have some more problem with date query.
1.how to return month from numeric to aalpabet.04-Apr.
2.how to return day or month without 0 in front.
i mean if day is 01-1,same also month if 02-2.
Is it possible.please help me.
Thanks in advance.
Hi,
1. date_format(datecolumn,'%b');
2. date_format(datecolumn,'%d)+0; or
if you want a string result
trim(leading '0' from date_format(datecolumn,'%d));
The manual has very clear description of date functions.
Anvar.
At 01:47 AM 05/04/2002 +, you wrote:
hi,
I have some more
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date in the
indate column. Is there anyway
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:50 AM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
=20
Hi all...
=20
This is my first post to the list. I've been working on MySQL=20
now for about a=20
week and really like it. I have a question that I can't find=20
in any
Hi Jim,
Welcome to our relatively?relationally happy band.
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
A whole week and no post...
When I add a line to my
See the manual reference to the 'timestamp' type.
-Original Message-
From: Jim Hatridge [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 5:50 PM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
Hi all...
This is my first post to the list. I've been working on MySQL
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date
On Friday 08 February 2002 19:28, Eric Mayers wrote:
Jim,
What you're asking about is the timestamp data type.
Look at : http://www.mysql.com/doc/D/A/DATETIME.html
In a nutshell, if you assign 'null' to a timestamp column it will put in
value of 'NOW()'.
Eric Mayers
Software Engineer
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date in the
indate column. Is there anyway
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date
:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:50 AM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
Hi all...
This is my first post to the list. I've been working on MySQL
now for about a
week and really like it. I have a question that I can't find
in any of the
books
Hi Jim,
Welcome to our relatively?relationally happy band.
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
A whole week and no post...
When I add a line to my
27 matches
Mail list logo