Advanced Search

Return to Snippet

Revision: 7538
at July 29, 2008 03:52 by retry
Initial Code 
TO_CHAR(date1,'YYYYMMDD')
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL