|
Posted by ZMAN on 01/14/07 00:05
"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:2f214$45a74d46$8259c69c$7798@news2.tudelft.nl...
> ZMAN wrote:
>> Hello All-
>>
>> I need to extract a result from a postgres database and PHP.
>> I need to get everything greater than today's date.
>> I'm comparing it against a timestamp field that can have something
>> like '2006-12-30 05:47:35.089-05' or NULL.
>> Basically:
>> SELECT * from table_name
>> WHERE timestamp_field is >= today
>>
>> I want the NULL values in the result set as well...
>>
>
> Euhm, not sure about postgres, in MySQL this works:
> WHERE timestamp_field >= NOW() OR timestamp_field IS NULL
> --
> Rik Wasmus
>
>
Thank you for your response. Stupid me, its "IS" NULL I was doing =
NULL.
It works great thanks very much!!
Navigation:
[Reply to this message]
|