From: "Dike" <[EMAIL PROTECTED]> Cmer, Maaf nih tanya lagi abish udah nyoba-nyoba nggak berhasil nih.. maaf saya copy-paste langsung yang udah di coba... Nah, datanya misal seperti di bawah... Yang mau di query format tanggal-bulan-tahun, tapi saya coba-coba kok yang bisa format DD ajah? :( mysql> select * from hdasql where user='siddik'; +--------+---------------------+----------------+--------------------------- --+------------+ | User | Date | Category | Item_Affected | UserID | +--------+---------------------+----------------+--------------------------- --+------------+ | siddik | 2000-12-07 15:32:47 | Phone Solution | Email-Configuration Problem | 0000000000 | | siddik | 2000-12-27 15:09:36 | Phone Info | Tanya Telpon | 0000000000 | | siddik | 2000-12-07 07:55:02 | Phone Info | Tanya Status Request | 0000000123 | | siddik | 2000-11-28 14:59:08 | Phone Info | Tanya Status Request | 0000000000 | | siddik | 2000-11-28 09:23:09 | Phone Info | Tanya Acc. User | 0000000123 | | siddik | 2000-11-28 07:58:52 | Phone Complain | App. Supply | 0000810319 | | siddik | 2000-11-27 15:52:02 | Phone Complain | Sys. Database Admin | 0000810319 | | siddik | 2000-12-08 14:40:00 | Email Info | - | 0000000000 | | siddik | 2000-12-08 14:44:27 | Phone Remedy | Remedy-App. Supply | 0000000000 | +--------+---------------------+----------------+--------------------------- --+------------+ 9 rows in set (0.00 sec) mysql> select * from hdasql where user='siddik' and date_format(Date,'DDMMYYYY')=08122000; mysql> select * from hdasql where user='siddik' and date_format(Date,'DDMMYYYY')='08122000'; mysql> select * from hdasql where user='siddik' and date_format(Date,'DDMMYYYY')="08122000"; mysql> select * from hdasql where user='siddik' and date_format(Date,'DD-MM-YYYY')='08-12-2000'; mysql> select * from hdasql where user='siddik' and date_format(Date,'MM')='08-12-2000'; mysql> select * from hdasql where user='siddik' and date_format(Date,'MM')=12; mysql> select * from hdasql where user='siddik' and date_format(Date,'YYYY-MM-DD')='2000-12-08'; mysql> select * from hdasql where user='siddik' and date_format(Date,'YYYYMMDD')='20001208'; etc... Hasilnya Empty set terus... :( kalo DD saja: mysql> select * from hdasql where user='siddik' and date_format(Date,'DD')=8; +--------+---------------------+--------------+--------------------+-------- ----+ | User | Date | Category | Item_Affected | UserID | +--------+---------------------+--------------+--------------------+-------- ----+ | siddik | 2000-12-08 14:40:00 | Email Info | - | 0000000000 | | siddik | 2000-12-08 14:44:27 | Phone Remedy | Remedy-App. Supply | 0000000000 | +--------+---------------------+--------------+--------------------+-------- ----+ 2 rows in set (0.01 sec) gimana yah kalo mau full kayak gitu? desc fieldnya: mysql> desc hdasql; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | User | varchar(50) | YES | | NULL | | | Date | datetime | YES | | NULL | | | Category | varchar(50) | YES | | NULL | | | Item_Affected | varchar(50) | YES | | NULL | | | UserID | varchar(10) | YES | | NULL | | +---------------+-------------+------+-----+---------+-------+ Ada yang bisa bantu???? and maaf banget berhubung saya jelasinnya banyak... :/, maklum nggak ada gurunya :p TIA, Dike -- Compu-Mania MailingList, provided by PT Centrin Utama Unsubscribe: [EMAIL PROTECTED], body: unsubscribe Compu-Mania Archive: http://www.mail-archive.com/[email protected]/ Info: [EMAIL PROTECTED], body: help
