Re: Using SELECT WHERE

Hey Michal,

Well, modify your select statement formatting the implant date including
the time and you'll answer your question yourself ;-)
What I'm saying is that a date field also includes time information and
this is causing your results.

Cheers,
Chris

Michal Lijowski wrote:

>I made a database and I would like to select entries
>which have data not equal to the specified date.
>I have postgresql-7.3.4-11 on Red Hat Fedora Core 1.
>
>Here is the command
>
>RabStudies=> SELECT RabNo, ImplantDate, Comments FROM RabStudiesInfo
>where implantdate <> 0001-01-01;
>
>and I get
>
> rabno | implantdate | comments
>
> 307 | 2004-02-23 | No mimetic No target
> 309 | 2004-02-23 | No mimetic No target; Frame 12 study terminated
> 314 | 2004-02-27 | No mimetic No target
> 311 | 2004-02-27 | No mimetic No target
> 310 | 2004-02-26 | No mimetic No target No decoy
> 315 | 0001-01-01 | No Tumor
> 320 | 0001-01-01 | No Tumor
> 316 | 0001-01-01 | No Tumor
> 313 | 0001-01-01 | No Tumor
>
>Why entries with implandate are listed?
>It is the same when I use != instead of <>.
>
>Thanks,
>
>Michal
>
>
>
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>