nichanson Posted July 28, 2008 Share Posted July 28, 2008 After meny hours trying to understand this unix time system, I wrote this code to post my database timestamp (I'm still a beginner): $time_st = date("h, m, s, d, m, y",$row['date']); $time_fn = mktime($time_st); $time2 = date("d M Y",$time_fn); Is this a valid way to do it as all the other tutorials make it sound so difficult or is there an easier way to do it? Nick Link to comment https://forums.phpfreaks.com/topic/116949-timestamp-query/ Share on other sites More sharing options...
fenway Posted July 28, 2008 Share Posted July 28, 2008 Why use timestamps at all? Insert a proper SQL-99 date YYYY-MM-DD HH:MM:SS Link to comment https://forums.phpfreaks.com/topic/116949-timestamp-query/#findComment-601723 Share on other sites More sharing options...
nichanson Posted July 29, 2008 Author Share Posted July 29, 2008 Sorry for late reply I'm sorry but I'm not familar with this technique as I've only just been getting into timestamps, if possible can you give a simple example. thx Nick Link to comment https://forums.phpfreaks.com/topic/116949-timestamp-query/#findComment-602299 Share on other sites More sharing options...
fenway Posted July 31, 2008 Share Posted July 31, 2008 That is, make it a proper DATETIME field. Link to comment https://forums.phpfreaks.com/topic/116949-timestamp-query/#findComment-604624 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.