Slam kenal Pak Eko Begini pak ada script yang saya kurang mengerti... "CONVERT(datetime, '" & Format(Now,"yyyy-MM-dd hh:mm:ss"',102)"
1. bagaimana jikalau kita ingin format tanggalnya dd/mm/yyyy, berapa nilai konstantanya ? 2. bagaimana jika nilai dari tanggal yang ingin kita masukkan tersebut berasal dari textbox, dibagian mana kita menuliskannya ? terima kasih banyak ya pak.. Bagus w Opie Purnama <[EMAIL PROTECTED]> wrote: pak eko, makasih ya, udah bisa.... ----- Original Message ----- From: "Eko Heri Susanto" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, April 13, 2005 5:56 PM Subject: [indoprog-vb] Re: mslh tgl di sql server > > >> ins = "insert into Temppo > (kdsup,kdbrg,fam,nmbrg,satuan,hrgbeli,hrgjual,disc,pesan,total,tgl,kd > peg)" & _ >> "values ('" & ckdsup & "','" & ckdbrg & "','" & cfam > & "','" & cnmbrg & "','" & csatuan & "'," & _ >> "'" & nhrgbeli & "','" & nhrgjual & "','" & ndisc & "','" > & Val(Text7.Text) & "','" & ntotal & "'," & _ >> "'" & Date & "','" & userid & "')" >> cn.Execute (ins) >> >> aku udah coba pake format(date,"dd/mm/yyyy") atau format > (now,"dd/mm/yyyy") >> tp masih tetap error yg sama euy.... > :: > Kalo di SQL server untuk memanipulasi tipe data datetime biasanya > menggunakan fungsi CONVERT, contoh : > 1. script insert into > Insert into MyTable (NoBrg, Tgl) Values ('001',CONVERT > (datetime,'2005-04-20 21:10:00',102)) > > 2.script select > Select * From MyTable WHERE (tgl BETWEEN CONVERT(datetime,'2005-04- > 20 21:10:00',102) AND CONVERT(datetime,'2005-04-30 21:10:00',102)) > > Angka 102 merupakan konstanta untuk format tanggal versi british > (tahun-bulan-tanggal jam:menit:detik) > > Jika statement tadi diterapkan di program anda kira2 scriptnya spt > ini: > ins = "insert into Temppo > (kdsup,kdbrg,fam,nmbrg,satuan,hrgbeli,hrgjual,disc,pesan,total,tgl,kd > peg)" & _ > "values ('" & ckdsup & "','" & ckdbrg & "','" & cfam & "','" & > cnmbrg & "','" & csatuan & "'," & _ > "'" & nhrgbeli & "','" & nhrgjual & "','" & ndisc & "','" & Val > (Text7.Text) & "','" & ntotal & "'," & _ > "CONVERT(datetime, '" & Format(Now,"yyyy-MM-dd hh:mm:ss" > & "',102),'" & userid & "')" > cn.Execute (ins) > > > > Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Small Business - Try our new resources site! [Non-text portions of this message have been removed] Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
