cast date format in sql server

Here is the infor syteline 8.02 's self-defined function: Copy Code code as follows: Midnightof ALTER FUNCTION [dbo]. [Midnightof] ( @Date DATETIME ) RETURNS DATETIME As BEGIN Return (DATEADD (datepart, @Date), DATEADD (month, DATEPART (month, @Date)-1), DATEADD (DATEPART ( Day, @Date)-1), '

SELECT CONVERT (varchar), CAST (@testFloat as Decimal (38,2))SELECT STR (@testFloat, 38, 2) Importing from Excel to sql2000, there is a list of "contacts" that have become float types, and I want to convert to nvarchar type, using the following statement Select convert (nvarchar), convert (int, contact) from employeeGo Data overflow, no! Select convert (nvarchar), CONVERT (Decimal (11,0), contact) from employeeGo Data Conversion Successful! SELE

Label:In SQL Server we often need to write a variety of SQL scripts, such as stored procedures and functions, because in the writing process, often adjust, some of the keywords we use uppercase, some we use the lowercase, some end use; For people with obsessive-compulsive disorder, it's very painful to look at code like this, and you have to manually

click " recommend " in the lower right corner. If you want to find my new blog more easily, click on " Follow me " If you want to give me more encouragement, you may wish to click on the right, " enjoy your stay" Blog is his own summary of the results of learning, learning to summarize the knowledge-"analysis of the problem-" to solve the problem. Where the views/descriptions in the text are incorrect, please correct them. Thank you for your reading, if you are interested in the content of my b

Label:Original: Anatomy of SQL Server 13th integers storage format in row compression and page compression (translated)Anatomy of SQL Server 13th integers storage format in row compression and page compression (translated)http://i

SQL Server Date functionDefinition and UsageThe CONVERT () function is a general function that converts a date to a new data type.The CONVERT () function can display date/time data in different formats.GrammarCONVERT (data_type (length), Data_to_be_converted,style)data_type

ff and DATEADD functions and their time interval, read the Microsoft online help.　　 Using the DATEDIFF and DATEADD functions to calculate a date is a bit different from the method used to convert from the current date to the date you need. You must consider the time interval. For example, how many time intervals are there between the current

Last Friday, to do a PHP connection to both the MySQL database and the SQL Server database MySQL has been used to SQL Server is not very familiar with, so stones. No other at least MySQL and SQL Server are relatives When you make

A very powerful date Formatting Function in SQL Server Select convert (varchar (100), getdate (), 0): 05 16 2006 AMSelect convert (varchar (100), getdate (), 1): 05/16/06Select convert (varchar (100), getdate (), 2): 06.05.16Select convert (varchar (100), getdate (), 3): 16/05/06Select convert (varchar (100), getdate (), 4): 16.05.06Select convert (varchar (100),

Label: 1 SELECT DateDiff(YY,'2010-06-1 10:10',GETDATE())--calculate how many years 2 SELECT DateDiff(Q,'2011-01-1 10:10',GETDATE())--Calculate how many quarters 3 months a quarter 3 SELECT DateDiff(MM,'2011-06-1 10:10',GETDATE())--calculate how many months 4 SELECT DateDiff(DD,'2011-06-1 10:10',GETDATE())--calculate how many days 5 SELECT DateDiff(WK,'2011-06-1 10:10',GETDATE())--calculate how many weeks 6 SELECT DateDiff(HH,'2011-06-10 10:10','2011-06-10 11:10')--calculate how many hours 7 SELE

// It is inconvenient to process dates in PHP, for example, to find the month with a different date? What should I do? // File name: date. inc. php3 // before using these two functions, convert the date or date to the timestamp type. // For example: // $ todaymktime (0, 0, 0, date