blueman378 Posted February 1, 2008 Share Posted February 1, 2008 hi guys i was wondering could anyone please tell me what settings to set the mysql column to so that when it is set it sets it with the current unix timestamp? cheers Matt Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/ Share on other sites More sharing options...
pdkv2 Posted February 1, 2008 Share Posted February 1, 2008 convert you date/time to unix time stamp using php and insert it in to the mysql column having the data type to eg int(11). Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-455138 Share on other sites More sharing options...
blueman378 Posted February 1, 2008 Author Share Posted February 1, 2008 so its not possible to have mysql do that for you? well it doesnt have to be the unix timestamp but it has to be some sort of time + date Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-455142 Share on other sites More sharing options...
Illusion Posted February 1, 2008 Share Posted February 1, 2008 UNIX_TIMESTAMP() NOW() SYSDATE() are of interest. Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-455507 Share on other sites More sharing options...
fenway Posted February 2, 2008 Share Posted February 2, 2008 hi guys i was wondering could anyone please tell me what settings to set the mysql column to so that when it is set it sets it with the current unix timestamp? cheers Matt You mean the TIMESTAMP column type? Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-456251 Share on other sites More sharing options...
blueman378 Posted February 3, 2008 Author Share Posted February 3, 2008 so if i set it to TIMESTAMP, when it was wrote to it would automatically insert the current timestamp? Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-456524 Share on other sites More sharing options...
AndyB Posted February 3, 2008 Share Posted February 3, 2008 so if i set it to TIMESTAMP, when it was wrote to it would automatically insert the current timestamp? What happened when you tested that technique? Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-456532 Share on other sites More sharing options...
blueman378 Posted February 4, 2008 Author Share Posted February 4, 2008 well it killed my comp.. or it may have been fluke timing... Quote Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-457453 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.