ROTECTED]>
Sent: Thursday, March 06, 2003 9:32 AM
Subject: Re: Syntax confusion
> At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote:
> >On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
> >[...]
> >> BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <=
At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote:
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59'
or
TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE i
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
> BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59'
>
> or
>
> TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a
timestamp, not a number of days.
As
s" <[EMAIL PROTECTED]>
To: "Jeff" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 8:51 AM
Subject: Re: Syntax confusion
At 8:40 +1000 3/6/03, Jeff wrote:
>Hi, perform the following query
>
>SELECT BA_ID, B
lt;[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 8:51 AM
Subject: Re: Syntax confusion
> At 8:40 +1000 3/6/03, Jeff wrote:
> >Hi, perform the following query
> >
> >SELECT BA_ID, BA_DATE
> >FROM BA
> >WHERE SU
At 8:40 +1000 3/6/03, Jeff wrote:
Hi, perform the following query
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
and get
'TSV12345-1','2003-02-25 00:00:00'
'TSV12345-2','2003-02-25 00:00:00'
'TSV14818-3','2003-02-19 00:00:00'
'TSV14836-00015','2003-02-27 00:00:00'
'T
