Forum

Mark,

Assuming you are doing this from inside your module view (PortalModuleBase), you can get the user's local time based on the server time like this:

var tz = UserInfo.Profile.PreferredTimeZone;
DateTime userlocalTime = DateTime.UtcNow.AddHours(tz.BaseUtcOffset.Hours);

Let me know if this is what you are looking for.

If you must go directly through the database, it seems like you need to get the timezone string from the UserProfile table like:

SELECT TOP 1 up.PropertyValue 
FROM UserProfile up JOIN ProfilePropertyDefinition pdef ON up.PropertyDefinitionID = pdef.PropertyDefinitionID
WHERE up.UserID = 1 AND pdef.PortalID = 0 
AND pdef.PropertyName = 'PreferredTimeZone'

This will give you something like 'Pacific Standard Time' which you will have to map (or create a lookup table) to get the GMT offset of that timezone string.  Then subtract the hours from the GETUTCDATE().