Advanced Search

Return to Snippet

Revision: 17413
at September 3, 2009 21:48 by rengber
Initial Code 
--UK/NZ format dd/mm/yyyy
select CONVERT(DATETIME, '21/03/2000', 103)

--US format mm/dd/yyyy
select CONVERT(DATETIME, '03/21/2000', 101)
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
I am forever forgetting this.  Have to look up the 101 vs 103 in books online every time.   
Also forget which way around is US/NZ format.  :-)

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
TSQL Convert DateTime

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
database, sql, simple

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL