Advanced Search

Return to Snippet

Revision: 40255
at January 28, 2011 02:48 by xavsio4
Initial Code 
and TABLE.THE_DATE = TO_DATE(TO_CHAR(sysdate(), 'DD')-1||TO_CHAR(sysdate(), 'MM')||TO_CHAR(sysdate(), 'YYYY'), 'DDMMYYYY') //this is to compare on the previous day
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Compare dates in Business Objects Data Integrator with Oracle

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL