OT MS SQL2000 question

["Dr John Tankard" <john@xxxxxxx>]

Sorry for the OT post,

I want to select from MS SQL2000 rows by a timestamp, but I only want to
use
the date part,  in DB2 you could do:-

Select * from table1 where created is like current date

but SQL2000 does not have current date, ou use getdate() which returns a
full time stamp of now which would only return a result set of rows where
the coloum created is exactly on the same time ?

Is there a easy way of saying 'although created it a timestamp return rows
created today' ?

John





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/