Maksudnya ingin mangambil nilai apa dari '200771231' ?
ga biasa sama oracle nih
Kalau ingin mandapatkan Day dari format karakter tersebut :
select day(cast('20071231' as smalldatetime))
Hasilnya 31 (integer)
Untuk jadi karakter:
select cast(day(cast('20071231' as smalldatetime)) as varchar(10))
RIKY ANDRIAN
IT - SRIKANDI GROUP
________________________________
7th Successive 2007 Dakar Rally Victory for MITSUBISHI From 2001 With PAJERO
EVOLUTION MPR13
12th Dakar Rally Victory for MITSUBISHI From 1982
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
mellon
Sent: Tuesday, April 03, 2007 9:09 PM
To: [email protected]
Subject: [indopb] dual bila di mssql
tolong dong
script berikut pakai di Oracle:
select to_char( to_date( '20071231' , 'yyyymmdd' ) , 'D' )
from dual
kalo pakai Mssql jadi bagaimana ?
please help me
thanks ya
sorry baru belajar.
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
