Link to home
Start Free TrialLog in
Avatar of ST3VO
ST3VOFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Problem with MySQL TimeStamp

Hi experts,

I hope you can help me!

I have created a table with a timestamp field.

The problem is that when I update the record (for example in PhpMyAdmin) it updates the date but
the time is always 00.00.00.

I need the date and time (timestamp) to be updated when the record is modified or new record it added.

Can anyone help please?

Thanks

ST3VO
Avatar of Terry Woods
Terry Woods
Flag of New Zealand image

I see this is a duplicate of:
https://www.experts-exchange.com/questions/23214050/MySQL-TimeStamp-Problem.html

If anyone wants to comment, perhaps they should post to that question.
You should probably request that this one be deleted. You can post questions that are "pointers" to a question in a different zone, although you probably would have been better posting one question covering both zones anyway. A pointer has zero points.
Sorry - i think pointer questions are 20 points each, being the minimum you can assign.
Avatar of ST3VO

ASKER

Hmm...I didn't know that :o(

Thanks for your solution on the other post :o)

Avatar of ST3VO

ASKER

So I cannot assign this points to you?

It would probably be a bit excessive. Better to request the other question be deleted...  cheers
Sorry - this question is the one that should be deleted!
Avatar of ST3VO

ASKER

Actually....I still have problems with it!

The problem has gone when editing or adding a new record via phpmyadmin BUT
when I try the now() function from the page I just get the date and now the date time ...Any ideas???

ASKER CERTIFIED SOLUTION
Avatar of Terry Woods
Terry Woods
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ST3VO

ASKER

That was the problem :o)  Work now thanks :o)