Advanced Search

Return to Snippet

Revision: 8939
at October 14, 2008 15:54 by hoffstein
Initial Code 
DATEADD(d, DATEDIFF(d, 0, @date), 0)
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Returns the date associated with a given datetime value (@date).

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
TSQL truncate time

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL