thanks atas sarannya it's very nice
--- Sistyo Alfan Tribowo <[EMAIL PROTECTED]>
wrote:
> Pernah pakai fungsi SQL Cast ?
>
>
>
> select cast('19 September 2006' as datetime)
>
> select cast('September 19 2006' as datetime)
>
> select cast('2006 September 19' as datetime)
>
>
>
> output dari ke-33nya adalah datetime, dgn format
> sesuai format tanggal
> SQLServer anda. Sebenarnya masalah anda bukan pada
> regional setting computer
> anda. Nothing to do with that . Yang perlu anda tahu
> adalah format tanggal
> SQL Servernya..
>
> tapi dengan fungsi cast, anda tidak perlu pusing
> cari tahu format tanggal
> SQL Servernya.. :-)
>
>
>
> jadi.. apapun format tanggal computer anda, apakah
> itu :
>
> 1 September 2006
>
> September 1 2006
>
> Dsb.. tidak masalah.
>
>
>
> Semoga bermanfaat..
>
>
>
> _____
>
> From: [email protected]
> [mailto:[EMAIL PROTECTED]
> On Behalf Of Heru Rahadyan
> Sent: 11 January 2006 06:41
> To: [email protected]
> Subject: RE: [Programmer-VB] Save Date to SQL SERVER
>
>
>
> mas, mungkin sebaiknya nyimpennya ngga usah pake
> CDATE, jd langsung aja
> format(.dtawal.value, "yyyy-mm-dd")
>
> tp CMIIW ya :)
>
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED]
> On Behalf Of Joshua Joe
>
> padu arsana i wayan <[EMAIL PROTECTED]> wrote:
>
> Dear VbMania,
>
> Saya punya masalah ni.
> Berikut beberapa cara yang saya pakai u/ menyimpan
> tanggal ke SQL Server dengan regional setting short
> date format >> dd/MM/yyyy
>
> misalkan tgl yang akan saya simpan :03/01/2005 (red:
> 03 januari 2005) jika saya simpan dgn cara :
> 1. Format(CDate(.dtAwal.Value), "yyyy-MM-dd")
> hasilnya
> 25/06/1905
> 2. Format(CDate(.dtAwal.Value), "MM-dd-yyyy")
> hasilnya
> 04/07/1894
> 3. Format(CDate(.dtAwal.Value), "MM-dd-yyyy")
> hasilnya
> 01/01/1900
> 4. Format(.dtAwal.Value, "MM-dd-yyyy") hasilnya
> 07/08/1894
>
> Pertanyaan saya :
> Bagaimana format sintax yang benar untuk menyimpan
> tanggal pada SQL Server di semua regional setting.
>
> Mohon pencerahan dan solusi dari teman2
>
> Thanks and Regards,
> Wayan
> BALI EXPORT CENTER
>
>
>
>
>
> __________________________________________
> Yahoo! DSL - Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>
>
>
> _____
>
> Yahoo! Photos
> Got holiday prints? See
>
<http://us.rd.yahoo.com/mail_us/taglines/holidayprints/*http:/pa.yahoo.com/*
>
http:/us.rd.yahoo.com/mail_us/taglines/photos/evt=38089/*http:/pg.photos.yah
> oo.com/ph/print_splash> all the ways to get quality
> prints in your hands
> ASAP.
>
> Wahana Programmer Indonesia Links:
>
>
>
>
>
>
>
> SPONSORED LINKS
>
>
> P
>
<http://groups.yahoo.com/gads?t=ms&k=Programmer&w1=Programmer&w2=Indonesia&w
>
3=Basic+programming+language&w4=Computer+programming+languages&w5=Programmin
>
g+languages&w6=Java+programming+language&c=6&s=157&.sig=QQ3jf-qPyCuDVOqmjxXL
> qQ> rogrammer
>
> In
>
<http://groups.yahoo.com/gads?t=ms&k=Indonesia&w1=Programmer&w2=Indonesia&w3
>
=Basic+programming+language&w4=Computer+programming+languages&w5=Programming
>
+languages&w6=Java+programming+language&c=6&s=157&.sig=gwDT36aV8hG5doSQaoUwS
> A> donesia
>
> Basic
>
<http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Programme
>
r&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languag
>
es&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=g8R4
> hday0%0d%0alm5D2hL5lG5aQ> programming language
>
>
> Computer
>
<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Progr
>
ammer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+lan
>
guages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=
> RLdM7%0d%0aFZAm3K7raX0D8KsjA> programming languages
>
>
> Programming
>
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programmer&w2=
>
Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5
>
=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=CtRXYvnoy
> 1O17U%0d%0aC430cphA> languages
>
> Java
>
<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Programmer
>
&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+language
>
s&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=XQJC4
> fZro9%0d%0apIX1bkqBwT8w> programming language
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "Programmer-VB
> <http://groups.yahoo.com/group/Programmer-VB> " on
> the web.
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]>
>
>
> * Your use of Yahoo! Groups is subject to the
> Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of
> Service.
>
>
>
> _____
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-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/
