Arsip: query tanggal di firebird

more 16 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 16 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 16 years ago
herux
Koreksi dikit ya bos ...
kalo firebird bulan di depan jadi '12/07/2008'
yg diatas MySql khan..?

more 16 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 16 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
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Mencari Pegawai Pensiun
by oshea in Tip n Trik Pemrograman more 12 years ago - cannot modify read only dataset
by arjuna_1982 in Hal umum tentang Pascal Indonesia more 15 years ago - Menyisipkan Record pada DbGrid
by IdrisZZ in Hal umum tentang Pascal Indonesia more 17 years ago - INSERT gak mau nge refresh?
by kupretkutu in MySQL more 18 years ago - saya butuh source nya MIDIread
by stevelie in Hal umum tentang Pascal Indonesia more 18 years ago - Nginput user and password conection otomatis
by fissas in MsSQL more 16 years ago - [OOT] TANYA masalah perintah SQL... dah mentog
by purnomo2007 in Enginering more 13 years ago - Edit Data Di mYsql
by felax in MySQL more 16 years ago - test ping ip
by bodoh in Network, Files, I/O & System more 15 years ago - mo buat program multiuser
by dhe_smart in Network, Files, I/O & System more 18 years ago