Very Computer

Hi,

I have some difficulties using datetime columns, probably I just don't
understand it.

Suppose I have a table with 2 columns: a date and an integer. The only
thing I want to do is insert a row every day with values current date and
1, and update a row by adding 1 to the integer column.

My problem is that I don't know how to insert just the current date in the
column. Even when using the smalldatetime data type SQL Server inserts the
time that the record was created, and not just the date. When, later that
day, I want to update that record, I can't find it. I want to do something
like

INSERT INTO Table VALUES ( currentdate, 0 )     and
UPDATE Table Set integervalue = integervalue + 1 WHERE date = currentdate

Can someone help me, please???

Hugo.

Hugo,

What you want to do is convert the datettime to a character string
without the time, then convert it back to datetime.  For example:

SELECT CONVERT(datetime, CONVERT(char(10), getdate(), 101))

This will leave the time set at midnight.

Roy

Hi William,

Look on David Solomns' web page http://www.metis.com/weeklytips.htm
and you will find a tip on datetime functions. This will provide you with a
good
overview/solution for your problem.

Best Regards
Trevor Dwyer

Quote:> Hi,

> I have some difficulties using datetime columns, probably I just don't
> understand it.

> Suppose I have a table with 2 columns: a date and an integer. The only
> thing I want to do is insert a row every day with values current date and
> 1, and update a row by adding 1 to the integer column.

> My problem is that I don't know how to insert just the current date in
the
> column. Even when using the smalldatetime data type SQL Server inserts
the
> time that the record was created, and not just the date. When, later that
> day, I want to update that record, I can't find it. I want to do
something
> like

> INSERT INTO Table VALUES ( currentdate, 0 )     and
> UPDATE Table Set integervalue = integervalue + 1 WHERE date = currentdate

> Can someone help me, please???

> Hugo.

select convert(char(8), getdate(), 1)

--------
01/22/97

(1 row(s) affected)

--
Michael Yocca Database Analyst PPG Industries, Inc., Pittsburgh, PA

President PGH SQL Server Users Group
http://users.sgi.net/~myocca/sql/pghssug
Why is it that they call the place you drive your car a parkway but, they
call the place that you park cars a driveway?
disclaimer "The opinions expressed are those of the writer and not of PPG
Industries, Inc. nor any PPG-associated company."

Quote:> Hi,

> I have some difficulties using datetime columns, probably I just don't
> understand it.

> Suppose I have a table with 2 columns: a date and an integer. The only
> thing I want to do is insert a row every day with values current date and
> 1, and update a row by adding 1 to the integer column.

> My problem is that I don't know how to insert just the current date in
the
> column. Even when using the smalldatetime data type SQL Server inserts
the
> time that the record was created, and not just the date. When, later that
> day, I want to update that record, I can't find it. I want to do
something
> like

> INSERT INTO Table VALUES ( currentdate, 0 )     and
> UPDATE Table Set integervalue = integervalue + 1 WHERE date = currentdate

> Can someone help me, please???
> Hugo.