Date and Time Functions

PHP & MySQL : http://php-mysql-solution.blogspot.com/
(semua tentang PHP & MYSQL, belajar PHP, tutorial PHP,dasar-dasar Mysql, tips & trik PHPMySQL, function PHP & class PHP)



mysql> SELECT DAYOFMONTH('2001-11-00'), MONTH('2005-00-00');
-> 0, 0

mysql> SELECT DATE_ADD('2006-05-00',INTERVAL 1 DAY);
-> NULL
mysql> SELECT DAYNAME('2006-05-00');
-> NULL

ADDDATE(date,INTERVAL expr unit), ADDDATE(expr,days)
mysql> SELECT DATE_ADD('1998-01-02', INTERVAL 31 DAY);
-> '1998-02-02'
mysql> SELECT ADDDATE('1998-01-02', INTERVAL 31 DAY);
-> '1998-02-02'

ADDTIME(expr1,expr2)
mysql> SELECT ADDTIME('1997-12-31 23:59:59.999999',
-> '1 1:1:1.000002');
-> '1998-01-02 01:01:01.000001'
mysql> SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');
-> '03:00:01.999997'

CONVERT_TZ(dt,from_tz,to_tz)
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
-> '2004-01-01 13:00:00'
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00');
-> '2004-01-01 22:00:00'

CURDATE()
mysql> SELECT CURDATE();
-> '1997-12-15'
mysql> SELECT CURDATE() + 0;
-> 19971215
ANDA INGIN Info????, silahkan Klik :

Info Hotel di Bali
Blajar PHP
Mau Buat Aplikasi WEB
Bola
Bola Mania
Info Bola
Donload MP3 Free
Check Kesehatan anda
Berita Hari Ini
Daftar Nama-nama Hotel
Musik Jadul
Tentang Alam
Harga HP
MOTO GP
NETWORK
Desa'ku
NETWORK Bali
Cinta KU
Motor Plus
Ngopi
Kelamin anda
Donload Tragedi Dunia
Bibirnya Gosip
Laptop Ku
Tanamanku
Virus MU

Related Post: