mcmuney Posted January 19, 2008 Share Posted January 19, 2008 My DB is recording date in this format: 1183098091 I'm trying to convert this into a date in Excel, but can't seem to do it. What format is that? Link to comment https://forums.phpfreaks.com/topic/86715-solved-date/ Share on other sites More sharing options...
revraz Posted January 19, 2008 Share Posted January 19, 2008 Unix Timestamp Link to comment https://forums.phpfreaks.com/topic/86715-solved-date/#findComment-443151 Share on other sites More sharing options...
mcmuney Posted January 19, 2008 Author Share Posted January 19, 2008 I know this is php board, but is there an excel formula to convert it? Link to comment https://forums.phpfreaks.com/topic/86715-solved-date/#findComment-443169 Share on other sites More sharing options...
revraz Posted January 19, 2008 Share Posted January 19, 2008 Google is your friend http://exceltips.vitalnews.com/Pages/T0096_Converting_UNIX_DateTime_Stamps.html Link to comment https://forums.phpfreaks.com/topic/86715-solved-date/#findComment-443175 Share on other sites More sharing options...
mcmuney Posted January 19, 2008 Author Share Posted January 19, 2008 Thanks javascript:void(0); Grin Link to comment https://forums.phpfreaks.com/topic/86715-solved-date/#findComment-443189 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.