I have create a Table has smalldateTime datatype
and I set its default value =getdate() funtion
when i insert new data i found it automatical insert '3/26/2005 2:53:00 PM'
And later I want to get all the record that i have inserted today
as this query SELECT * FROM MY TABLE'S NAME WHERE Publish_Date=GETDATE()
I GET NO ROCORD
WHAT 's problem ? How to do to fixed this error ?

thanks for your help

When you use GetDate() is also has current time along with today's date so when you compare it will not return any result?

SELECT field1, field2...
FROM MyTable
WHERE DateDiff(dd, publish_date, GetDate())=0

OR

SELECT *
From Table6
WHERE Convert(varchar(10),publish_date,101) = Convert(varchar(10), GetDate(),101)

yes
shahchi1 is right.

atul

Yes ! You are all right
Thanks shahchi1