[Sussex] Postgresql date fields

Brendan Whelan b_whelan at mistral.co.uk
Thu Oct 27 10:24:16 UTC 2005


Ronan wrote:
>Anyone know the SQL syntax for checking to see if a date field in
>postgres is empty?  Having a bit of a dunce day and can't work it out,
>despite RTFMing!!!

>Any postgresers out there?

I use MySQL and the syntax would be 
select * from my_table where my_field = ""

Hope this helps, Brendan


> _______________________________________________
> Sussex mailing list
> Sussex at mailman.lug.org.uk
> Sussex LUG Website: http://www.sussex.lug.org.uk/
> http://mailman.lug.org.uk/mailman/listinfo/sussex






More information about the Sussex mailing list