Saya salah ngetik, harusnya memang DAO. Ternyata memang harus pakai
day. Tanda kutip tunggal (') nggak ngaruh.
DATE_FORMAT tetap "undefined function 'DATE_FORMAT' in expression".
Tapi biarlah, utk sementara bisa nggak dipakai.
Terima kasih banyak man...
--
Eddy S. Wibowo
--- In [email protected], Purwedi Kurniawan
<[EMAIL PROTECTED]> wrote:
> sedikit pelurusan mas, kalau liat kode yg mas buat, mas bukannya
pake ADO
> tapi pake DAO.
> trus u. query yg dayofmonth di kode yg
> "select * from ajb_tmlogajuan where dayofmonth(tglkeputusan)='20'")
> coba diganti jadi
> "select * from ajb_tmlogajuan where dayofmonth(tglkeputusan)=20")
> coba cek datatype dari field tglkeputusan itu, datetime atau string?
> kalau gak mau juga coba pake fungsi day(tglkeputusan).
> u. fungsi date_format juga biasanya ga ada masalah, asalkan
formatnya benar
> spt: SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
