dear seniors Mohon advisenya bagaimana menulis syntax ini memakai sql server didlm powerbuilder?
// Start Date select to_char( add_months( to_date( :ls_yyyymm , 'yyyymm' ) , -1 ) , 'yyyymm' ) || '16' into :ls_start_dt from dual ; // Start Day Number select to_number( to_char( to_date( :ls_start_dt , 'yyyymmdd' ) , 'd' ) ) into :li_start from dual; // Between Day select to_date( :ls_last_dt , 'yyyymmdd' ) - to_date( :ls_start_dt , 'yyyymmdd' ) + 1 into :li_between from dual ; select to_char( to_date( :ls_start_dt , 'yyyymmdd' ) + :jnx - 1 , 'yyyymmdd' ) , decode( to_char( to_date( :ls_start_dt , 'yyyymmdd' ) + :jnx - 1 , 'd' ) , '1' , 'P' ,'7','P', 'K' ) , decode( to_char( to_date( :ls_start_dt , 'yyyymmdd' ) + :jnx - 1 , 'd' ) , '1' , '0' , '7' , '0' , '8' ) into :ls_day , :ls_day_type , :ls_wk_hour from dual ; thanks sebelumnya ----------------------------------------------- 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/
