Umarni don canzawa daga UnixTime zuwa Na al'ada

Lokuta da yawa da nake samun kwanuka a cikin tsarin Unix, a bayyane ban fahimci wani aljani ba na kwanan wata da lokacin da suke nuna min, a nan ne ya zama dole a maida abin da ke cikin UnixTime zuwa "al'ada".

Amma, da farko tambaya:

Menene Lokacin Unix?

Muna iya karantawa wikipedia kuma za mu ga cewa lambar da ke gabanmu ita ce yawan sakan da suka wuce tun daga 1 ga Janairun 1970 har zuwa wannan lokacin, wani abu kamar "1437905791" a zahiri yana nufin: 2015-07-26 10:16:31

A ina zan sami kwanan wata a cikin Tsarin Lokacin Unix?

Yawancin aikace-aikace da yawa suna adana ranaku ko lokuta a cikin wannan tsarin a cikin rumbun adana bayanan da suke amfani da su, tattaunawa, sabar aikace-aikacen, da dai sauransu.

Yadda zaka canza daga tashar UnixTime zuwa wani abu da zaka fahimta?

Mai sauƙi, a ce muna da kwanan wata mai zuwa: 1416483005

Don canza shi zuwa wani abu da zamu iya fahimta, kawai sanya: kwanan wata -d @

Wannan shine:

date -d @1416483005

Kuma hakan zai gaya mana abin da yake wakilta a ranar 20 ga Nuwamba, 2014, da ƙarfe 06:30:05

maida-unix-lokaci

Shin akwai gidan yanar gizon da za a canza daga UnixTime?

Ee tabbas, bincika a Google «kwanan wata zuwa unix»Kuma voila, zasu ga da yawa sakamakon.

Zan iya samun ingantaccen kwanan wata MySQL kwanan wata?

Ee tabbas, daukarsa shine tushen bayanan da ake kira stats, tebur ake kira sau, kuma suna da filin da ake kira kwanan wata wanda yake a cikin tsarin Unix, tambayar don samun duk bayanan daga wannan filin da aka canza zai kasance:

select FROM_UNIXTIME(date) from stats.times;

Wato, muna da wani aiki da ake kira FROM_UNIXTIME () wanda ke taimaka mana don wannan jujjuyawar, idan a cikin kwaskwarimar da muka sanya filin wanda bayanin sa iri ne, sai ya canza mana.

Karshe!

Da kyau babu sauran ƙari da yawa, ji daɗi!


Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Wanda ke da alhakin bayanan: Miguel Ángel Gatón
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.

  1.   Saron m

    álaaaaa ba su san cewa za a yi amfani da wannan tsarin ba, wanda ke da ƙafa, bari mu ga abin da ke faruwa lokacin da lambar ta kai iyakar ƙwaƙwalwar ajiyar mai canjin. Arshen mutanen duniya, kowa yayi kuskure, a ƙarshe zai zama unix wanda ya gaya mana yaushe.

  2.   Mario Guillermo Zavala Silva m

    Abin da kyau kwarai bazawa… !! Godiya ga bayanan !!!

    Murna…

  3.   nisanta m

    Ccze log colorizer yana da zaɓi don canza tsarin kwanan wata na unix.

    tailf /varlog/squid3/access.log | cizo -C

  4.   Armando Hutu m

    Matsayi mai kyau, yana da matukar amfani sanin umarnin, lokacin unix shine ciwon kai idan kaga log, kuma idan kaga lambar kawai baka san menene kwanan wata a cikin wannan tsarin ba.

    1.    Azureus m

      Daidai, menene fuck yana tambayarku lokacin da lahira wani abune ya faru a cikin tsarin kuma rashin sanin yadda ake fassara hakan.

  5.   lokacin3000 m

    Kyakkyawan ra'ayi don nuna lokaci tare da Babban Lokaci.

  6.   ruwan sama m

    Ina yin gwaje-gwaje tare da lokaci.h a cikin c tare da lokaci (0) yana ba ni sakanni tun daga 1970, Na san akwai kayan aikin da ke yin ta atomatik amma ina so in gan ta da hannu
    Na kara shekara ta 1970 zuwa adadin shekarun da suka shude tun daga lokacin, na samu shekarun da ake raba dakika da 60 don samun mintuna sannan kuma in samu awowi sannan tsakanin 24 kuma na samu ranakun 365 na karshe kuma na samu shekarun.
    shekara mai tsawo = 1970 + ((lokaci (0) / 60/60/24/365)); ya ba ni kwanan wata

    don yawan watan na dauki kwanan wata kuma na debe dakika daga ranar har zuwa shekarar da ta gabata, amma har yanzu ina da sakan daga shekarar da ta gabata.
    long numdelmes=time(0)-(((time(0)/60/60/24/365)-1)606024365);

    Na dauki lambobi kuma na raba shi da 60 don samun mintuna sannan kuma da 60 don samun awanni, sauran shekara. Ina da adadin ranaku a wannan shekara yanzu na ɗauki ragowar ragin tsakanin 7 kuma suna ba ni kwanakin
    long diasemana=((numdelmes/60/60/24)-365)%7;

    Ina maimaita aikin amma ban sake raba 7 ba amma 31 kuma ina samun lambar watan
    numdelmes=((numdelmes/60/60/24)-365)/31;

  7.   factory m

    Babban labarin, ya kasance cikakke bayyane, Ina kuma so in jaddada aikin al'umma, a cikin maganganun an kuma bayyana shakku da yawa kuma ba abu ne mai sauƙi ba samun mutane kamar wannan suna bin shafin yanar gizo. A 10.