Can I do an UPDATE on a Timestamp field???

[gradinumcp]

Hi! I am creating a time management system whereby the administrator can go in and UPDATE an existing Timestamp field with a new time.

I have the administrator input the date and time in a textbox.

Any clue how he can update the field with this new data??? The table TimeTable has columns like TimeStamp, DateStamp and UserID besides Autonum.

I think it should be something like...

UPDATE TimeTable set TimeStamp=06/29/2005 12:45:56 PM where UserID=10 and DateStamp=06/29/2005

This however errors on me--any clues???

 

[lgarner]

Try:

... set TimeStamp='2005-06-29 12:45:56' where ...

 

[gradinumcp]

Thanks lgarner--it says query executed succesfully. But does not update the database at all.

Any clues???

 

[johnwm]

Depending on the version and the DB type you're using TIMESTAMP values will behave differently for details:

http://www.mysqlfreaks.com/mysql/manual_Reference.html#DATETIME

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[TonyGroves]

[tt]... WHERE UserID=10 AND DateStamp='2005-06-29'[/tt]

 

[gradinumcp]

Thanks Guys that worked. However when i try to integrate it into my ASP code, it doesn't work. Maybe I will post it in the ASP forum.

However the SQL query works well

Thanks Again!!!