select convert(varchar,getdate(),112) tp type-nya jd varchar yach ..
--- mellon <[EMAIL PROTECTED]> wrote: > dear seniors PB, > > mau banyak tanya nih, mumpung libur 4 hari: > > pertanyaan pertama : > jika aku ingin format date 'yyyymmdd' memakai > database sql server bgm > caranya? > karena biasanya aku memakai database oracle9i & > PB6.5 > > ini contoh syntaxku jika memakai database oracle > select to_date(sysdate,'yyyymmdd) > from dual; > hasilnya 20060525 ( misal sekarang tanggal 25 mei > 2006 ) > > fungsi dual (jika di oracle) kalo di sql server apa? > > > pertanyaan kedua : > kalo aku ingin memakai fungsi jika dan hanya jika di > sql server bagaimana? > ini contoh syntax jika aku memakai database oracle9i > dan PB6.5 > select decode(job_title,'Supervisor', decode ( sex > ,'Male','OKE'),'TIDAK > OKE') > from emp_tabel ; > fungsi decode (jika dioracle) di sql server apa? > > thank b4 > Moko > > > __________________________________________________ > Apakah Anda Yahoo!? > Lelah menerima spam? Surat Yahoo! memiliki > perlindungan terbaik terhadap spam > http://id.mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Everything you need is one click away. Make Yahoo! your home page now. http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- IndoPB - Indonesia PB User Group Learn PB6 by download FasTrack to PB6 at : http://groups.yahoo.com/group/indopb/files/Belajarpb6/ To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
