| Author |
Message |
madi |
| Location: |
|
Post subject: query tanggal di firebird
 Posted: 15/Jul/2008 11:22
|
|
onProfessional
Joined: 30-Dec-2005
Posts: 527
Status: Offline
|
|
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.... |
_________________
"MAN BEHIND THE GUN"
Hidup ini sudah terlalu banyak masalah, Tambah satu masalah tidak jadi masalah.
Hidup ini simple, jgn dijadikan complex.
|
| |
|
|
|
 |
|
deLogic |
| Location: Jakarta |
|
|
Post subject: RE: query tanggal di firebird
Posted: 15/Jul/2008 12:29
|
|
onMage
Joined: 04-Jul-2005
Posts: 2282
Location: Jakarta
|
|
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...  |
_________________
.:: Lagi gak pengen pasang signature ::.
|
| |
|
|
|
|
|
herux |
| Location: Kediri |
|
|
Post subject: RE: query tanggal di firebird
Posted: 15/Jul/2008 21:55
|
|
onProfessional
Joined: 13-Jul-2006
Posts: 668
Location: Kediri
Status: Offline
|
|
Koreksi dikit ya bos ...
kalo firebird bulan di depan jadi '12/07/2008'
yg diatas MySql khan..? |
|
|
| |
|
|
|
|
|
fresh |
| Location: |
|
|
Post subject: RE: query tanggal di firebird
Posted: 16/Jul/2008 07:45
|
|
onIntermediate
Joined: 08-Jul-2008
Posts: 55
Status: Offline
|
|
@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 |
|
|
| |
|
|
|
|
|
deLogic |
| Location: Jakarta |
|
|
Post subject: RE: query tanggal di firebird
Posted: 16/Jul/2008 10:14
|
|
onMage
Joined: 04-Jul-2005
Posts: 2282
Location: Jakarta
|
|
|
|
|
|
|
amyra |
| Location: Big Park, Mount Tea Land, CENTRAL JAVA |
|
|
Post subject: RE: query tanggal di firebird
Posted: 16/Jul/2008 15:24
|
|
onSkilled
Joined: 18-Mar-2006
Posts: 78
Location: Big Park, Mount Tea Land, CENTRAL JAVA
Status: Offline
|
|
| Yup, kalau saya biasa pake SqlTimeStamp, agak ribet tapi OK2 saja. |
_________________
Rakyat bersatu TAK TERKALAHKAN
Rakyat bertato TAK BISA DISALAHKAN
|
| |
|
|
|
|
|
|
