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....
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.
