Posted by Yas on 07/04/07 14:53

Hi,

I am creating creating a table with a Date column dd-mm-yyyy. But I
cant seem to find a SQL function that just returns today's date.
getDate() returns the time as well so I cant use it.

The reason is simply that I want to update/overwrite over and over
again all records from current day but not touch the ones from
yesterday etc and with the timestamp in there I just end up adding
more and more rows for the same day.

In other words I only want to preserve rows are from yesterday or
older but overwrite ones from today.


Any help will be appricated.

Thank you!

Yas

• Next in forum: Re: MS SQL getDate() Function remove Time
• Prev in forum: Find website from email address
• Thread view: MS SQL getDate() Function remove Time

[Reply to this message]