Yala ukuguqula kusuka ku-UnixTime kuye kokujwayelekile

Izikhathi eziningi lapho ngithola khona izinsuku ngefomethi ye-Unix, kusobala angiqondi i-daemon yokuthi bangibonisa luphi usuku nesikhathi, lapho kulapho kudingeka khona ukuguqula okuku-UnixTime kube "okujwayelekile".

Kepha, okokuqala umbuzo:

Siyini Isikhathi se-Unix?

Singafundela Wikipedia futhi sizobona ukuthi inombolo ephambi kwethu yinombolo yamasekhondi adlulile kusukela ngoJanuwari 1, 1970 kuze kube yileso sikhathi, into efana ne- "1437905791" empeleni isho: 2015-07-26 10:16:31

Ngizithola kuphi izinsuku ngefomethi ye-Unix Time?

Izinhlelo eziningi zivame ukonga izinsuku noma izikhathi kule fomethi ku-database abayisebenzisayo, izinkundla, amaseva wohlelo lokusebenza, njll.

Ungaguquguqula kanjani usuke endaweni yokugcina ye-UnixTime uye entweni ongayiqonda?

Kulula, ake sithi sinedethi elandelayo: 1416483005

Ukuyiguqula ibe yinto esingayiqonda, vele ubeke: usuku -d @

Leyo:

date -d @1416483005

Futhi lokho kuzositshela ukuthi kumeleni ngoNovemba 20, 2014, ngo-06: 30: 05

guqula-unix-time

Ingabe ikhona iwebhusayithi engaguqulwa isuka ku-UnixTime?

Yebo kunjalo, sesha ku-Google «usuku lokuxhuma»Futhi i-voila, bazobona okuningi imiphumela.

Ngingaluthola usuku oluqondile eliguquliwe lwe-MySQL?

Yebo kunjalo, ukucabanga ukuthi i-database ebizwa izibalo, kubizwe itafula izikhathi, futhi ube nenkambu ebizwa ngokuthi usuku olukufomethi ye-Unix, umbuzo wokuthola yonke idatha kusuka kuleyo nkambu eguquliwe isivele izobe:

select FROM_UNIXTIME(date) from stats.times;

Lokho wukuthi, sinomsebenzi obizwa ngokuthi FROM_UNIXTIME () osisizayo kulokhu kuguqulwa, uma ngaphakathi kubakaki sifaka inkambu imininingwane yayo engaleyo hlobo, iyiguqulela kithi.

Isiphetho!

Hhayi-ke akukho okunye okuningi ongangeza, ukujabulele!


Amazwana ayi-9, shiya okwakho

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.

  1.   i-saeron kusho

    U-álaaaaa wayengazi ukuthi leyo fomethi izosetshenziswa, okuyi-orthopedic, ake sibone ukuthi kwenzekani lapho inombolo ifinyelela kwinkumbulo ephezulu yokuguquguqukayo. Ukuphela kwezwe abafana, wonke umuntu ubengalungile, ekugcineni kuzoba unix ositshela ukuthi nini

  2.   UMario Guillermo Zavala Silva kusho

    Yeka incwadi enhle kakhulu… !! Siyabonga ngolwazi !!!

    Jabulela…

  3.   isihlibhi kusho

    I-ccze log colorizer inenketho yokuguqula ifomethi yosuku lwe-unix.

    umsila /varlog/squid3/access.log | ccze -C

  4.   I-Armando Leisure kusho

    Okuthunyelwe okuhle kakhulu, kuyasiza impela ukwazi umyalo, isikhathi se-unix siyikhanda lapho ubona i-log futhi uma ubona kuphela inombolo awazi ukuthi usuku luni ngale ndlela.

    1.    I-Azureus kusho

      Impela, yini le fuck ekubuza yona lapho kwenzeka isihogo umcimbi wohlelo futhi ungazi ukuthi ukuhumusha kanjani lokho.

  5.   eliotime3000 kusho

    Umbono omuhle ukukhombisa isikhathi nge-Unixtime.

  6.   imvula kusho

    Bengilokhu ngenza izivivinyo nge time.h in c nge time (0) inginikeza imizuzwana kusukela ngo-1970, ngiyazi ukuthi kukhona amathuluzi akwenzayo ngokuzenzakalela kepha bengifuna ukuyibona ngesandla
    Ngifaka u-1970 kunani leminyaka elidlulile kusukela lapho, ngithola iminyaka ehlukanisa imizuzwana ngama-60 ukuthola imizuzu ngiphinde ngithole amahora bese kuba phakathi kuka-24 bese ngithola izinsuku zokugcina ezingama-365 bese ngithola iminyaka.
    unyaka omude = 1970 + ((isikhathi (0) / 60/60/24/365)); inginika usuku lwamanje

    ngenombolo yenyanga ngithatha usuku lwamanje bese ngikhipha imizuzwana kusuka osukwini kuze kube unyaka owedlule, kepha ngisenayo imizuzwana yangonyaka odlule.
    long numdelmes=time(0)-(((time(0)/60/60/24/365)-1)606024eyodwa);

    Ngithatha ama-numdelmes bese ngiwahlukanisa ngama-60 ukuthola amaminithi futhi ngiphinde ngithole ama-60 ukuthola amahora, unyaka wonke. Sengivele nginenani lezinsuku kulo nyaka manje ngithatha okusele kokuhlukaniswa phakathi kuka-7 futhi banginika izinsuku
    long diasemana=((numdelmes/60/60/24)-365)%7;

    Ngiyayiphinda inqubo kodwa angisahlukanisi ngo-7 kodwa ngo-31 futhi ngithola inombolo yenyanga
    numdelmes=((numdelmes/60/60/24)-365)/31;

  7.   Factory kusho

    I-athikili enhle, icace bha, futhi ngifuna ukugcizelela umsebenzi womphakathi, kumazwana ukungabaza okuningi kuyacaciswa futhi akulula ukuba nabantu abanjena balandela i-blog. A 10.