From: "Dike" <[EMAIL PROTECTED]>
> From: Ryo Saeba <[EMAIL PROTECTED]>
> Ini gue pake Oracle ya:
>
> select * from testdb where user = 'isuhari' and
> to_char(date,'DDMMYYYY') =
> '06112000';
>
> Itu bakal me-list semua record dengan user isuhari yang date-nya
> bertanggal
> 6 November 2000.
Mas Ch, nggak bisa euy... :(, ada errornya:
You have an error in your SQL syntax near '(date,'DDMMYYYY') = '06112000''
at line 1
Apa mungkin saya pake mysql jadi lain? :( solusi yang di kasih tau mas
hernawan secara japri:
select * from table where userid = 'isuhari' and to_char(date,'DD-MON-YYYY
HH:MI:SS') like '6%';
Juga sama, errornya pas di (date...etc.. kenapa yah... :( apa mysql nggak
kenal command to_char? :(
TenQ mas CH,
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
