Forum


HomeHomePremiumPremiumAdministrationAdministrationTime stamps in DNN SiteTime stamps in DNN Site
Previous
 
Next
New Post
9/25/2013 7:40 AM
 

Hi Aderson,

I noticed that the times listed in various areas of one of my DNN sites are not accurate.  For example, When I view User Accounts the Last Login Column shows correct date but incorrect time.  I checked my Admin site settings and I have the right time zone setup.    It seems to be showing eastern time and I have Pacific time zone selected in my site settings.  Also when I create reports with DNN Reports module or do SQL queries, same is true...wrong times listed.   Is this something to do with where the server is that hosts the site?  If so can something be done to correct this?

 
New Post
9/25/2013 9:07 AM
 

Hi Hutch,

I had noticed some date discrepancies on DNN sites. I think the dates are stored in the DB in the same timezone the server is setup with. If you don't control your server, you cannot control much of this. So if you query the DB directly, it will show the date/time as the data was created based on the server timezone.

Now when it displays via DNN it will try to adjust the date/time stored with the same timezone set under Site Settings/Advanced Settings/Security Settings / Timezone. I don't think it does a good job on that.

Bottom line is that I think this is either a bug or just something that I couldn't figure out how it works. I usually just try to have the site timezone and the server timezone set to the same, but I realize this is not always possible, specially for users who host their sites on shared hostings.

Aderson

 
Previous
 
Next
HomeHomePremiumPremiumAdministrationAdministrationTime stamps in DNN SiteTime stamps in DNN Site



Try FREE
30 days money back guaranteed