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 --- Dwi Kristianto <[EMAIL PROTECTED]> wrote: > +++ On Wednesday 01 December 2004 16:59, jogy sinaga > wrote [[Delphindo] tanya > SQL tanggal dan jam tertentu sampai tanggal dan jam > tertentu]: > : numpang tanya... > : ada yang tau query SQL tanggal dan jam tertentu > sampai > : tanggal dan jam tertentu? > : misal tanggal 01/12/04 10:00:00 AM sampai 02/12/04 > : 06:00:00 AM. > : untuk keperluan absen. > : thanks yah > > sebetulnya sudah ada di arsip. > > kalo yg ini berlaku umum. > coba baca2x help, cari bagian tparam di bagian > method asdatetime > nah, sql statementnya harus dilengkapi > paramater/variabel sql. > > -- > http://www.dwikris.cjb.net | ym: steamboatid > __________________________________ Do you Yahoo!? All your favorites on one personal page � Try My Yahoo! http://my.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/i7folB/TM --------------------------------------------------------------------~-> Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] 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: http://docs.yahoo.com/info/terms/
