Arsip: query tanggal di firebird

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

more 12 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 12 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
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- Gimana ambil data dari Excel yang tidak konsisten?
by hendra_sir84 in Hal umum tentang Pascal Indonesia more 13 years ago - Tanya: Cara kerja dbImage di Quick Report
by cintik in Hal umum tentang Pascal Indonesia more 15 years ago - Delphi on google [SEARCH !!, Before you Ask]
by eksant in OOT more 12 years ago - Lebaran
by donald in OOT more 12 years ago - QuickReport-PageFooter
by ichan29 in Tip n Trik Pemrograman more 13 years ago - Not Install
by muktaf in Tip n Trik Pemrograman more 12 years ago - send email pada delphi 7
by shindo in Hal umum tentang Pascal Indonesia more 12 years ago - Bikin Aplikasi di LINUX
by delphi_warrior in onLinux more 13 years ago - bertanya tentang maksud error message dan maksud code
by nekok in Network, Files, I/O & System more 10 years ago - pdf git-scm version control 2010, wajib dibaca!
by mambamaestro in Enginering more 10 years ago