[Sussex] Postgresql date fields

Angelo Servini Angelo.Servini at claybrook.co.uk
Thu Oct 27 10:35:32 UTC 2005


Hi Ronan

I dont really know PostGres that much, but in other SQL's 

	Select * from MyTablename where MyDateField is NULL

or you could use:

	Select * from MyTablename where MyDateField is NOT NULL

where you want non empty fields.

would do the trick.

However, it may be like ORACLE where NULL values are treated as empty string, so

	Select * from MyTablename where MyDateField = ''

might work.

I hope this is of use.


--
Angelo Servini
Programmer/Analyst
Claybrook Computing Ltd
Sutherland House
Russell Way
Crawley
West Sussex.  RH10 1UH
* 01293 604955
* 01293 604099 (Fax)
* angelo.servini at claybrook.co.uk




The above information is confidential to the addressee and may be privileged.  Unauthorised access and use is prohibited. If you received this message in error please tell us by reply (or telephone the sender) and delete all copies from your system.

Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. This e-mail message has been swept for the presence of detectable computer viruses, but we cannot guarantee that it is virus-free and you should scan this email for viruses prior to opening or saving any attachments.

If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

Please note that communications sent by or to any person through our system administrator.

Claybrook Computing Limited (Registered in England and Wales No 1287205) is a subsidiary of Claybrook Computing (Holdings) Limited
Registered Office: Sutherland House, Russell Way, Crawley, West Sussex RH10 1UH

A Xafinity Limited Company





More information about the Sussex mailing list