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 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). 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 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. 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? 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? 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? 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... Link to comment https://forums.phpfreaks.com/topic/88864-really-simple-question/#findComment-457453 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.