Arsip: query tanggal di firebird

more 14 years ago
madi
hmm...maaf nih klo mang dah di bahas...
tapi dicari2 koq lom nemu2 jg
setelah dicoba2 masih gagal..
select from user where tanggal > 12/07/2008 // keluar pesan error cannot convert string
select from user where tanggal > 07/12/2008 // keluar pesan error converstion not support
trus yang bener gimana ya format query tanggal di firebird..?
tengkyu atas jawabannya....

more 14 years ago
deLogic
coba ini:
select from user where tanggal > '2008-07-12';
select from user where tanggal > '2008/07/12';
halah pake tag sql malah tanda '<' berubah .. yo wis gak pake tag sql aja dah... :D

more 14 years ago
herux
Koreksi dikit ya bos ...
kalo firebird bulan di depan jadi '12/07/2008'
yg diatas MySql khan..?

more 14 years ago
fresh
@herux
Dua-duanya bisa :
QuotedStr(FormatDateTime('MM/dd/yyyy',Tanggal))
QuotedStr(FormatDateTime('MM-dd-yyyy',Tanggal))
QuotedStr(FormatDateTime('yyyy/MM/dd',Tanggal))
QuotedStr(FormatDateTime('yyyy-MM-dd',Tanggal))
CMIIW

more 14 years ago
deLogic
Biar lebih manstab... :
How to set the Firebird date format or why doesn't dd/mm/yyyy work?
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 2 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 10 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 10 years ago
Random Topic
- help ZylBattery 1.23 Delphi 7 Component for xp
by dedidavidbala in Tutorial & Community Project more 11 years ago - Bisa suruh IE simpan ke file .MHT dari Delphi?
by jrp in Tip n Trik Pemrograman more 16 years ago - Acces ke tabel di komputer lain
by goehsatrio in Tip n Trik Pemrograman more 15 years ago - Tolong bantuain, masalah CreateForm
by hendra_sir84 in Hal umum tentang Pascal Indonesia more 15 years ago - project setelah di run, berhenti
by yadi in Hal umum tentang Pascal Indonesia more 15 years ago - Pic & Avatar rekan Betamax (Splitted)
by DelphiExpert in OOT more 14 years ago - total jumlah bulan??
by darkwind in MySQL more 14 years ago - wordwrap pada dbgrid??
by imunk in Hal umum tentang Pascal Indonesia more 17 years ago - Jaringan ??
by budi_bunga in OOT more 16 years ago - mautahu tentang delphi
by fijarteguh in Tutorial & Community Project more 15 years ago