Coba WHERE convert(varchar,attendance_time,103) = cast('" & dtpicker.value & "'
as varchar)
Soalnya cast nggak bisa pakai ",103)
PS : kalau 102, formatnya yyyy.mm.dd (pakai titik)
Liung's
www.apktntajd.com (Ape Kate Ente Aje Deh!)
----- Original Message -----
From: McBoenBoen
To: [email protected]
Sent: Friday, August 31, 2007 4:10 PM
Subject: Re: [Programmer-VB] Mohon Pencerahan SQL Statement lagi
saya sudah coba ganti seperti ini tapi masih tetap error mas,
"WHERE convert(varchar,attendance_time,102)=cast('" &
DTPicker1.Value & "' as varchar,102)" & _
salam,
mc
[EMAIL PROTECTED] wrote:
Masalahnya convert() dibandingkan dengan cast() yg anda buat adalah varchar
vs datetime.
Nggak nyambung. Harus diganti jadi varchar vs varchar atau datetime vs
datetime.
Thanks
Liung's
www.apktntajd.com (Ape Kate Ente Aje Deh!)
----- Original Message -----
From: McBoenBoen
To: [email protected] ; Waroeng VB ; [EMAIL PROTECTED]
Sent: Friday, August 31, 2007 3:10 PM
Subject: [Programmer-VB] Mohon Pencerahan SQL Statement lagi
Dear Pakar VB,
mohon pencerahan kenapa stement SQL ini eror?
cn.Execute "INSERT INTO
temporary_tbl(nopp,attendance_id,day_shift,attendance_time,attd_info,dd_day)" &
_
"SELECT nopp,attendance_id,day_shift, attendance_time,
attd_info,dd_day FROM attendance_trx" & _
"WHERE (convert(varchar, attendance_time, 103))=cast('" &
DTPicker1.Value & "' as datetime)" & _
"ORDER By attendance_id, npp, attendance_id "
eror terjadi pada Convert
NOTE : type filed attendance_time adalah DateTime isinya "28/08/2007
10:25:11 AM"
atas bantuan teman2 sebelumnya byk terimkasih.
salam,
mc
.
.
