coba kamu pake query ini select date_format(sysdate() ,'%Y%m%d')
semoga membantu regards, Wahyu ----- Original Message ---- From: mellon <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, April 3, 2007 9:09:15 PM 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. ____________________________________________________________________________________ Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools.search.yahoo.com/toolbar/features/mail/
