At 11:01 +0300 on 05/26/2004, Egor Egorov wrote about Re: DATETIME question:
John Mistler <[EMAIL PROTECTED]> wrote:
Given a column DATETIMEcolumn (-MM-DD HH:MM:SS), is there a SELECT
statement that will:
select all entries whose (TIME) of DATETIMEcolumn is BETWEEN 'HH:MM:SS'
Use the time_format function.
-Original Message-
From: John Mistler
To: [EMAIL PROTECTED]
Sent: 5/26/04 1:15 AM
Subject: DATETIME question
Given a column DATETIMEcolumn (-MM-DD HH:MM:SS), is there a SELECT
statement that will:
select all entries whose (TIME) of DATETIMEcolumn is BETW
John Mistler <[EMAIL PROTECTED]> wrote:
> Given a column DATETIMEcolumn (-MM-DD HH:MM:SS), is there a SELECT
> statement that will:
>
> select all entries whose (TIME) of DATETIMEcolumn is BETWEEN 'HH:MM:SS' AND
> 'HH:MM:SS', but whose (DATE) is anything?
>
SELECT .. FROM t1 WHERE DATE_FORMA
