![]() |
Adding Timestamps in SQL?
Okay, this should be stupidly easy, but I can't figure it out :(
I have this table in my database: PHP Code:
PHP Code:
I have a section of code that previews the article and constructs the timestamp in exactly the same way and that works fine. Shouldn't this just work? What am I missing here? |
It looks like a data type issue. Take a look at the docs for MySQL's TIMESTAMP datatype.
Quote:
|
Thanks, I've changed the data type of 'release_date' and it's all working as designed now :)
I was assuming the TIMESTAMP data type meant epoch timestamp but apparently not... |
| All times are GMT. The time now is 05:05 AM. |
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0