I need to write a sybase query that will have a where clause with date within last x days like so - 

```
SELECT *
FROM table_name
WHERE 
date_col > [_last_x_days]

```

I was able to get datetime of last x days using

```
dateadd(day, -x, getdate())

```

However, the above method still gives me the time element based on when the query is run. How can I strip down the time part?  

 i.e. convert **10-10-2011 15:00:45** to **10-10-2011 00:00:00** 

Also, is there a better way to do this?

Thanks in advance!!!

J