sql - CURRENT_UTC_TIME and timezone issues -



sql - CURRENT_UTC_TIME and timezone issues -

i hope understand , help me.

my sql server in south africa(gmt+2)

my application in usa (gmt-6)

my client(mobile) in south africa, in brazil (gmt-4).

the lastupdatetime of record in table supposed 10:25am while client time 4:25am. @ time server indicates 2:25am (or that)

i taught can utilize getutcdate function in sql insertions. questions are:

how convert old records' lastupdatetime utc date automatically?

is conversion thought or may in application?

how can allow config of server timezone in web.config file appsetting section (this in order mention every time server timezone changes)?

there 2 different ways acceptable store value lastupdatetime:

in terms of utc, in datetime or datetime2 field in terms of local time, in datetimeoffset field

if you've stored local time in datetime field, value potentially ambiguous. conversion utc require external knowledge of how original info captured.

if values captured sql's getdate statement, time zone of sql server relevant. south africa's time utc+02:00, can either:

keep value in same field , subtract 2 hours adjust utc or, re-create value datetimeoffset field, leaving orignal value , using utc+02:00 offset.

however, if value obtained in time zone, need know time zone was. might run problems daylight saving time, many time zones not fixed single offset.

you said application in usa gmt-6, doesn't create sense. central time in usa alternates between utc-06:00 , utc-05:00, while mount time in alternates between utc-07:00 , utc-06:00. you'll need know time zone was, , you'll have prepared potential overlap due fall-back daylight saving time transition.

with regards whether web.config file - that's more of asp.net question, rather sql server one. however, can tell there's no magic config setting this. application must correctly utilize datetime datetimekind.utc, or utilize datetimeoffset, , may need involve timezoneinfo conversions. it's impossible offer improve advice here, because haven't shown code , broad topic.

sql sql-server timezone

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more