database - Convert like America/New_York in MySQL server 2008 R2 server -

-

13:30:00 friday april 19, 2013 in america/new_york converts 09:30:00 friday april 19, 2013 in america/anchorage

convert in sql server 2008 r2.

using select query.

please me on this.

thanks,

we convert in java wright "america/new_york" america/anchorage way need select query convert est time other time zones..please not time zone cannot given met,gmt , all...

please note:- time zones plain text america/anchorage

you looking function:

convert_tz(dt,from_tz,to_tz)

convert_tz() converts datetime value dt time zone given from_tz time zone given to_tz , returns resulting value. time zones specified described in section 10.6, “mysql server time zone support”. function returns null if arguments invalid.

https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_convert-tz


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

jsf - disable onscroll event of the icefaces datatable -

-
i used ice:datatable component display data, somehow there default onscroll event in target div doesn't make sense me , had brought positioning problems other float elements within page. want disable action, didn't find approach control this. it called function below: var input = document.getelementbyid('targetid'); cleartimeout(ice.pid); ice.pid = settimeout(function() { input.value = document.getelementbyid('targetid_scroll').scrolltop; window.icesubmitpartial(null, input, event); }, 400); i had similar problem icefaces , upgraded jsf , icefaces versions best solution change tags: ice:datatable tag ace:datatable , columns inside ice:column ace:column . but, if didn't upgrade icefaces version, guess use javascript or jquery in point of code removing onscroll attribute, like: document._getelementsbyxpath("//div[contains(@onscroll,'scroll')]")[0].removeattribute("onscroll") this 1 i...
Read more