On Wednesday 05 February 2003 02:07, aah at volunteermatch dot org wrote:
> >Description:
>
> Multiple IS NULL tests in a WHERE clause appear to be broken
> when testing NOT NULL date fields. Queries work fine against
> varchar and int, probably(?) others.
>
> >How-To-Repeat:
>
>Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
>How-To-Repeat:
create temporary table test (a date not null, b date not null);
inser
>Description:
This is a simple bug with dates and 'between' operator. Full data is
supported below, but for the start I show the very essence of the problem. I
use the latest stable version of MySQL - 3.23.52.
SELECT weeks.ix FROM team, weeks WHERE
team.ix=6 AND
weeks.start > team.ctime A
On 04.04.2001 08:49:07 Nanjunda BM Prasad wrote:
> i have set the system format of date as DD/MM/. Is there any
> additional things to do ? pls. send me the solution.
use date_format to return the date in any format you want.
--
Hello,
I have created a table in mysql that has a date field, i have written
an asp code which saves the date in Mysql -MM-DD format but when
retrieving the content of the field it returns in m/d/yy format although
i have set the system format of date as DD/MM/. Is there any
addi
