Mudah2xan bisa bantu
1. bagaimana jikalau kita ingin format tanggalnya dd/mm/yyyy, berapa
nilai konstantanya ?
anda coba buka sql Query analyzer, tulis convert , kemudian block
tulisan convert tersebut, dan tekan shift+F1, atau lsg buka Books Online
nya
Cari tentang Convert..
2.bagaimana jika nilai dari tanggal yang ingin kita masukkan tersebut
berasal dari textbox, dibagian mana kita menuliskannya ?
Anggap textbox tersebut txttgl ya..... jadi gini
Insert into tabel1(tgl) values('" & format(txttgl.text,"yyyy-mm-dd
hh:mm:ss") & "'"
Salam
Ronald Irawan ( System Dev )
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
Bagus Wicaksono <[EMAIL PROTECTED]>
Sent by: [email protected]
15/04/2005 04:07 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: [indoprog-vb] Re: mslh tgl di sql server
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
[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/
