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? Quote 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 Quote 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? Quote 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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/86715-solved-date/#findComment-443189 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.