arunkar Posted March 31, 2008 Share Posted March 31, 2008 Hi, The date field in int(11) on mysql databse, the data stored is 10 digits numeric eg: 1206363465 I need to convert this to normal date so I Can do date compensation and pull out the registration today. How do I do this on MYSQL. Could not get much help from googling it though... Arun Link to comment https://forums.phpfreaks.com/topic/98752-conert-10-digit-unix-timestamp-date-form-mysql-db-to-normal-date/ Share on other sites More sharing options...
PFMaBiSmAd Posted March 31, 2008 Share Posted March 31, 2008 Use the mysql FROM_UNIXTIME() function to produce a yyyy-mm-dd hh:mm:ss datetime that you can then use in a meaningful way in your query. Link to comment https://forums.phpfreaks.com/topic/98752-conert-10-digit-unix-timestamp-date-form-mysql-db-to-normal-date/#findComment-505350 Share on other sites More sharing options...
arunkar Posted March 31, 2008 Author Share Posted March 31, 2008 Thanks PFMaBiSmAd. Link to comment https://forums.phpfreaks.com/topic/98752-conert-10-digit-unix-timestamp-date-form-mysql-db-to-normal-date/#findComment-505453 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.