View previous topic :: View next topic |
Author |
Message |
nel`chee
Joined: 08 Jul 2004 Posts: 2087 Location: Rijeka
|
Posted: 04.07.2006 19:54 Post subject: vremenske zone |
|
|
zanima me kako preoblikovati ovaj red, da bi na vrijeme iz baze dodala +6 sati
Code: | $when = date( "d.m.Y \u H:i", strtotime($myrow['time'])); |
hvala. |
|
|
Back to top |
|
|
unique
Joined: 29 Mar 2004 Posts: 655
|
Posted: 04.07.2006 21:12 Post subject: |
|
|
Code: | $when = date( "d.m.Y \u H:i", strtotime($myrow['time'])+6*60*60); |
|
_________________ Activate interlock! Dynotherms connected! Infracells up! Mega thrusters are go! LET'S GO VOLTRON FORCE! |
|
Back to top |
|
|
carr
Joined: 13 Nov 2003 Posts: 1397 Location: Karlovac
|
|
Back to top |
|
|
carr
Joined: 13 Nov 2003 Posts: 1397 Location: Karlovac
|
Posted: 04.07.2006 21:22 Post subject: |
|
|
kasnim |
_________________ Bolje biti malo lud, nego malo pametan. |
|
Back to top |
|
|
Sulien
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 04.07.2006 21:26 Post subject: |
|
|
vidim da vadiš time iz baze kao string i onda ga pretvaraš u integer, da bi nakon toga opet posao string
zašto odmah ne izvučeš integer (UNIX timestamp) is baze?
Code: | "SELECT UNIX_TIMESTAMP(time) AS time FROM ..." |
|
|
|
Back to top |
|
|
nel`chee
Joined: 08 Jul 2004 Posts: 2087 Location: Rijeka
|
Posted: 04.07.2006 21:52 Post subject: |
|
|
ne vadim samo vrijeme iz baze nego cijeli red, pa je ovo ipak krace.
@unique i carr: to sa dodavanjem sekundi sam pokusavala ali na string umjesto timestampa zato mi nije radilo... poslije sam se sjetila, ali tad mi komp nije bio blizu.. eh hvala
ovo za timezone_get sam gledala ali mi nije bas bilo jasno kako da to upotrijebim. |
|
|
Back to top |
|
|
unique
Joined: 29 Mar 2004 Posts: 655
|
Posted: 04.07.2006 22:00 Post subject: |
|
|
Sulien wrote: | vidim da vadiš time iz baze kao string i onda ga pretvaraš u integer, da bi nakon toga opet posao string
zašto odmah ne izvučeš integer (UNIX timestamp) is baze?
Code: | "SELECT UNIX_TIMESTAMP(time) AS time FROM ..." |
|
e to! al sad je kasno, a nije mi se dalo ic gledat u mysql manual za takvu nekakvu funkciju
btw. jel bolje onda spremat u tablicu kao time tip ili npr. 32bit unsigned int i u njega trpat time() ? jel mozda mysql vise voli svoj poznati tip al kolko vidim postoji dosta mysql funkcija za unix timestamp.... |
_________________ Activate interlock! Dynotherms connected! Infracells up! Mega thrusters are go! LET'S GO VOLTRON FORCE! |
|
Back to top |
|
|
nel`chee
Joined: 08 Jul 2004 Posts: 2087 Location: Rijeka
|
Posted: 04.07.2006 22:47 Post subject: |
|
|
hmmm nisam puno razmisljala o tome jer mi nije neki big dil, samo sam kao tip odabrala TIMESTAMP i kao default CURRENT_TIME pa neka on sam bira kako ce spremiti.. |
|
|
Back to top |
|
|
carr
Joined: 13 Nov 2003 Posts: 1397 Location: Karlovac
|
Posted: 05.07.2006 00:36 Post subject: |
|
|
nel`chee wrote: | ne vadim samo vrijeme iz baze nego cijeli red, pa je ovo ipak krace. |
Code: | SELECT *, UNIX_TIMESTAMP(time) AS time FROM .. |
pa ces imati cijeli row + vrijeme |
_________________ Bolje biti malo lud, nego malo pametan. |
|
Back to top |
|
|
Sulien
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 05.07.2006 11:50 Post subject: |
|
|
unique wrote: | btw. jel bolje onda spremat u tablicu kao time tip ili npr. 32bit unsigned int i u njega trpat time() |
treba uvijek koristit DATE, DATETIME ili TIMESTAMP (ovisno o potrebi)
@carr: ne znam čitaš li The Daily WTF (trebao bi!) ali ovo mi je jedan od boljih:
http://thedailywtf.com/forums/thread/75982.aspx
Sjetio sam ga se jer je ontopic totalno trganje
Last edited by Sulien on 05.07.2006 12:02; edited 2 times in total |
|
|
Back to top |
|
|
unique
Joined: 29 Mar 2004 Posts: 655
|
Posted: 05.07.2006 11:57 Post subject: |
|
|
[quote="Sulien"] unique wrote: | Sulien wrote: | btw. jel bolje onda spremat u tablicu kao time tip ili npr. 32bit unsigned int i u njega trpat time() |
treba uvijek koristit DATE, DATETIME ili TIMESTAMP (ovisno o potrebi) |
a zasto
btw. nauci se quotat |
_________________ Activate interlock! Dynotherms connected! Infracells up! Mega thrusters are go! LET'S GO VOLTRON FORCE! |
|
Back to top |
|
|
Sulien
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 05.07.2006 12:03 Post subject: |
|
|
nauči se i ti |
|
|
Back to top |
|
|
unique
Joined: 29 Mar 2004 Posts: 655
|
Posted: 05.07.2006 12:35 Post subject: |
|
|
Sulien wrote: | nauči se i ti |
btw. sta ovdje ne valja, javlja syntax error u liniji 3
Code: | CREATE TABLE network_address (
user_id MEDIUMINT UNSIGNED NOT NULL,
ip_addr INT UNSIGNED NOT NULL,
mac_addr BIGINT UNSIGNED NOT NULL DEFAULT 0,
INDEX USING BTREE (user_id,ip_addr,mac_addr),
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE
) ENGINE=InnoDB; |
edit: promjenio sam addr u address i sad je ok |
_________________ Activate interlock! Dynotherms connected! Infracells up! Mega thrusters are go! LET'S GO VOLTRON FORCE! |
|
Back to top |
|
|
carr
Joined: 13 Nov 2003 Posts: 1397 Location: Karlovac
|
Posted: 05.07.2006 14:26 Post subject: |
|
|
ne čitam, ali je ovo provala
Quote: | Apparently nobody sees the real value of this solution.
Let's say you ask a customer when he will pay and his answer is "when hell freezes over" .
In a normal database, all you can do is entering "31.12.2199" or null or some other magical value.
This system allows to enter a row into dates_tb with DateDesc="when hell freezes over" and DateDate=null until you find out when hell will freeze over.
|
a nije da nije primjenjivo na hrvatsko trziste |
_________________ Bolje biti malo lud, nego malo pametan. |
|
Back to top |
|
|
|