updating table with datetime

[Jimmy Jim]

OK, I have a datetime field in a table and when I ran an update like
so:

UPDATE myTable SET number=2 WHERE ID=50

I had the old datetime information in the table and that got
overwritten when I did the update. Now I am sure there is no way of
getting that back (yup, believe it or not I didn't do a backup) but
just a general question, should i have done the update like so:

UPDATE myTable SET number=2, mydatetimefield=mydatetimefield WHERE
ID=50

to keep the same information in the datetime field?? Just curious. If
anyone can help, it would be greatly appreciated.

JJ

[Rob Baxter]

Are you sure the column type is datetime and not timestamp? A
timestamp field is automatically updated whenever you insert or update
a row. If that's the case then I believe you are out of luck.

</rob>

ja************@yahoo.com (Jimmy Jim) wrote in message news:<8e**************************@posting.google. com>...

OK, I have a datetime field in a table and when I ran an update likeou a
so:

UPDATE myTable SET number=2 WHERE ID=50

I had the old datetime information in the table and that got
overwritten when I did the update. Now I am sure there is no way of
getting that back (yup, believe it or not I didn't do a backup) but
just a general question, should i have done the update like so:

UPDATE myTable SET number=2, mydatetimefield=mydatetimefield WHERE
ID=50

to keep the same information in the datetime field?? Just curious. If
anyone can help, it would be greatly appreciated.

JJ

[Rob Baxter]

Are you sure the column type is datetime and not timestamp? A
timestamp field is automatically updated whenever you insert or update
a row. If that's the case then I believe you are out of luck.

</rob>

ja************@yahoo.com (Jimmy Jim) wrote in message news:<8e**************************@posting.google. com>...

OK, I have a datetime field in a table and when I ran an update likeou a
so:

UPDATE myTable SET number=2 WHERE ID=50

I had the old datetime information in the table and that got
overwritten when I did the update. Now I am sure there is no way of
getting that back (yup, believe it or not I didn't do a backup) but
just a general question, should i have done the update like so:

UPDATE myTable SET number=2, mydatetimefield=mydatetimefield WHERE
ID=50

to keep the same information in the datetime field?? Just curious. If
anyone can help, it would be greatly appreciated.

JJ

[Jimmy Jim]

I think you are right Rob. That sux, I will have to do some playing
around, but needless to say I screwed up the dates on the records. Oh
well, lessons learned.

Thanks again!

JJ

ro*@microjuris.com (Rob Baxter) wrote in message news:<ac**************************@posting.google. com>...

Are you sure the column type is datetime and not timestamp? A
timestamp field is automatically updated whenever you insert or update
a row. If that's the case then I believe you are out of luck.

</rob>

ja************@yahoo.com (Jimmy Jim) wrote in message news:<8e**************************@posting.google. com>...

OK, I have a datetime field in a table and when I ran an update likeou a
so:

UPDATE myTable SET number=2 WHERE ID=50

I had the old datetime information in the table and that got
overwritten when I did the update. Now I am sure there is no way of
getting that back (yup, believe it or not I didn't do a backup) but
just a general question, should i have done the update like so:

UPDATE myTable SET number=2, mydatetimefield=mydatetimefield WHERE
ID=50

to keep the same information in the datetime field?? Just curious. If
anyone can help, it would be greatly appreciated.

JJ

[Jimmy Jim]

I think you are right Rob. That sux, I will have to do some playing
around, but needless to say I screwed up the dates on the records. Oh
well, lessons learned.

Thanks again!

JJ

ro*@microjuris.com (Rob Baxter) wrote in message news:<ac**************************@posting.google. com>...

Are you sure the column type is datetime and not timestamp? A
timestamp field is automatically updated whenever you insert or update
a row. If that's the case then I believe you are out of luck.

</rob>

ja************@yahoo.com (Jimmy Jim) wrote in message news:<8e**************************@posting.google. com>...

OK, I have a datetime field in a table and when I ran an update likeou a
so:

UPDATE myTable SET number=2 WHERE ID=50

I had the old datetime information in the table and that got
overwritten when I did the update. Now I am sure there is no way of
getting that back (yup, believe it or not I didn't do a backup) but
just a general question, should i have done the update like so:

UPDATE myTable SET number=2, mydatetimefield=mydatetimefield WHERE
ID=50

to keep the same information in the datetime field?? Just curious. If
anyone can help, it would be greatly appreciated.

JJ