--- In [EMAIL PROTECTED], jogy sinaga <[EMAIL PROTECTED]> wrote:
> Thanks Zamrony udah bantu...
> tapi yang gue bingung buat parameternya itu lho
> biasanya kalo field tanggal:
> Param[i].value := someday.Date;//pilihan user
> ato kalo field jam:
> Param[i].value := sometime.Time;
>
> tapi kalo datetime field bingung??? hehe..dah stupid
> nih, akhir tahun mampus....
>
Kalo datetime, coba params[i].asDatetie:=now;
coba-coba saja, ada date, time, dan datetime.
> gue pake MySQL 3.54 dan ZQuery Zeos
>
> thanks yaa, juga teman2 yg laen...
>
>
>
> Message: 1
> Date: Wed, 1 Dec 2004 17:31:55 -0800 (PST)
> From: Zamrony P Juhara <[EMAIL PROTECTED]>
> Subject: Re: tanya SQL tanggal dan jam tertentu sampai
> tanggal dan jam
> tertentu
>
> coba sql:
>
> SELECT * FROM table_absen
> WHERE field_tgl BETWEEN '2004-12-01 10:00:00' AND
> '2004-12-02 06:00:00'
>
> syntax ini utk MySQL karena format datetime mysql
> adalah YYYY-MM-DD, untuk server database lain tinggal
> disesuaikan format datetime-nya
>
>
>
> __________________________________
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
> http://promotions.yahoo.com/new_mail
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
