Nanya lagi, kalo data dalam bentuk date/time kok ga bisa ya, di Mysql
datanya jadi 0000:00:00, sepertinya format di Mysql yyyy-mm-dd
sedangkan di Access-nya dd-mm-yyyy.
Mohon bantuannya merubah formatnya jadi yyyy-mm-dd. (sudah coba manual
di tabel access dibuat format yyyy-mm-dd, tetapi tetap tidak bisa),
kayaknya harus pake script lagi.
Terima kasih atas bantuannya.
terlampir filenya yang pakai date/time
On 1/13/11, Ahmad Qomaruddin <ud13en@gmail.com> wrote:
> Terima Kasih Pak Hariyanto sudah bisa,
> biar saya explore lagi, nanti kalo mentok tanya2 lagi
>
> 2011/1/11 hari yanto <har_i20002000@yahoo.com>
>
>>
>> [Attachment(s) <#12d74953fc887711_TopText> from hari yanto included
>> below]
>>
>> Terlampir saya sudah coba perbaiki. Mudah-mudahan bermanfaat.
>>
>>
>> Hariyanto (Surabaya)
>>
>>
>>
>
>
>
> --
> Ahmad Qomaruddin
> Sulang Rembang Jawa Tengah Indonesia
> email : ud13en@gmail.com
> blog : ud13en.blogspot.com
>
--
Ahmad Qomaruddin
Sulang Rembang Jawa Tengah Indonesia
email : ud13en@gmail.com
blog : ud13en.blogspot.com
<*>Attachment(s) from Ahmad Qomaruddin:
<*> 1 of 1 File(s) http://groups.yahoo.com/group/belajar-access/attachments/folder/1845325456/item/list
<*> CobaDatabaseMysql.rar
------------------------------------
SPAM IS PROHIBITEDYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
No comments:
Post a Comment