Msql Time different with local Time

[nisitha]

Mysql වල CURTIME(), CURDATE() වලින් db එකට push කරාම. Godaddy server එකේ time එකයි date එකයි තමයි database එකට යන්නේ.
ඒක හදාගන්නේ කොහොමද ?
Php walin get time zone එක set කරාට වැඩක් උනේ නෑ !!

[root]

@nisitha said in Msql Time different with local Time:

set කරාට වැඩක් උනේ නෑ !!

server time zone eka maru karanna,

https://hostpapasupport.com/set-timezone-php-php-ini/

[nisitha]

@root machan oya option eka nane date.timezone

[dev_lak]

mysql wala CURTIME(), CURDATE() mewagen date time ganne php timezone eken nemei, mysql server eke timezone eken, mysql server eke timezone eka change krnna

[nisitha]

@dev_lak kohomada machan change karanne ?

[dev_lak]

danata tyena timezone eka balanna

SELECT @@global.time_zone;

aluth time zone ekak set krnna (ekak query ekak use karanna)

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';

[root]

@dev_lak cpanel eken server time eka maru karama ekath maru wenawa.

[Nisal Vimukthi]

Windows license key ekak use krala active krada ? ehema nam e license key eka aithi rate timezone wetenne