Advanced Search

Return to Snippet

Revision: 20014
at November 4, 2009 14:31 by highlyevolved
Initial Code 
CONVERT(VARCHAR(10), "Enter Date/time field/parameter", "format type")

Example: CONVERT(VARCHAR(10), GETDATE(), 101)


Formats:

"101" selects Date
"108" selects Time
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
These statements convert a date/time field into just a date or a time field

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Convert Date/Time in SQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, date, convert

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL