Saya pernah menggunakan format seperti dibawah ini
date1=Format(Dtpicker.value,"dd-mm-yyyy")
dan ternyata terbentur oleh regional setting, sedangkan
date1=Format(Dtpicker.value,"yyyy-mm-dd") , mau apapun regional setting nya tidak ada masalah
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| Bambang Triono <[EMAIL PROTECTED]>
Sent by: [email protected] 30/09/2005 05:01 PM
|
|
bisa dijelaskan lebih detil mas....
Ronald Irawan <[EMAIL PROTECTED]> wrote:
date1=Format(Dtpicker.value,"yyyy-mm-dd") lebih aman
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| Junus Sinuraya <[EMAIL PROTECTED]>
Sent by: [email protected] 30/09/2005 04:09 PM
|
|
Mungkin lebih baik menggunakan seperti ini,
date1=Format(Dtpicker.value,"dd-mm-yyyy")
Smoga membantu
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Bambang Triono
Sent: Friday, September 30, 2005 1:52 AM
To: [email protected]
Subject: [Programmer-VB] [OOT] Syntax SQL insert dengan DTPicker......
Sahabat vbersss..... saya sedang membuat aplikasi, salah satu formnya saya menggunakan DTPicker..agar lebih mudah...
saat perintah syntax SQL saya masukkan koq error yach... dianggap tidak bisa convert ke settingan tanggal padahal di syntax SQL sudah saya set convert.....
......CDate(DTPicker.Value)....
kenapa yach...
Di SQL Server saya
menghubungkannya saya pakai ODBC.... apa harus pake SQLOLEDB....
ada yang bisa bantu saya...
tipe field tanggal di SQL 2000 sudah saya arahkan ke smalldatetime....
ada bisa bantu untuk memecahkannya....
Terima Kasih....
Send instant messages to your online friends http://uk.messenger.yahoo.com
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the
Yahoo!
Terms of Service.
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
