Re: Help! SQL example needed for date comparison!
Date: 1997/12/12
Message-ID: <66rrsk$p7p_at_gilbaby.dinoco.de>#1/1
An example for sybase would be:
select * from telephone_book where datediff(dd,my_datetime,getdate()) = 1
: >ah262_at_detroit.freenet.org wrote:
: >>
: >> I am in urgent need of some SQL sample code that takes a database
: >> DATETIME formatted field and compares it to the system date (minus one
: >> day) for equality. I am, in effect, attempting to pull the records from
: >> a table dated 1 day previous from the current system date. Sounds
: >> simple, eh? I've looked at using the various date functions that Informix
: >> provides, but each one is very specialized in the resulting value it
: >> produces.
: >
: >I do not understand:
: > select * from table
: > where table.datecolumn=today-1
: >
: >does not work ?
: >
: >Michal
: >
: >--
: >--------------------------------------------------------------
: >Michal Hajek mailto:hajek_at_nspuh.cz
: >Sprava NIS http://www.nspuh.cz
: >NsP Uherske Hradiste phone : voice +420 0632 529 204
: >Purkynova 365 fax +420 0632 551 014
: >686 68 Uherske Hradiste Czech Republic
: >--------------------------------------------------------------
-- ************************************************************************** Gil Payson gil_at_gilbaby.dinoco.de g.payson_at_edina.xnc.com grp_at_geac.com **************************************************************************Received on Fri Dec 12 1997 - 00:00:00 CET