arabic date format

Transformation just saw a brother to ask the question, finished just found already knot paste, depressed ah ~ ~ Just see this thing is useful, so posted out from the reward hehe Ideas: At first the thought of using Select, for the loop to convert

Just saw a brother to ask the question, finished just found already knot paste, depressed ah ~ ~ Just see this thing is useful, so posted out from the reward hehe Ideas: At first the thought of using Select, for the loop to convert each Arabic

Case: compile a function to convert the input Chinese date to the Arabic digit date. For example, from January 1, 2012 to January 21, to December 21. (Process "10" Question: 1. * day 10; 2. day 13; 3. 23; 4. day 30 ;)In section 4, the translation of

In sqlserver2000, convert is used to obtain the processing result of the datetime data type style (full) date data format. Two examples are as follows: CONVERT (varchar (16), time 1, 20: 2007-02-0108:02 * The time is generally the * CONVERT (varchar

Use convert in SQL server2000 to obtain the datetime data type style (full) Processing of date data format: CONVERT (varchar (16), time 1, 20) Result:/* The time is generally the getdate () function or the field in the data table */ Result of

? In sqlserver, convert is used to obtain the processing of datetime data format (full). Two examples are as follows: CONVERT (varchar (16), time 1, 20) Result: 2007-02-0108:02 * The time is generally the * CONVERT (varchar (10), time 1, 23) Result

Use convert in Sql server2000 to get datetime data type style (full) Date data format processing, two examples: CONVERT (varchar (16), time one, 20) Result: 2007-02-01 08:02/* time is generally getdate () function or field in Datasheet * *

How SQL SERVER 2000 obtains the current system time with SQL statementsis to use GETDATE (); getdate in SQL () January 08, 2008 Tuesday 14:59A very powerful date format function in SQL Server Copy Code code as follows: Select CONVERT

1.date--> StringFunctions used: Date_format (date,format) Date: Dates to convert format: formatted styleFormat Style collation:Year: %Y display four-bit: %Y only show the latter two bits: 15Month: %M Month in English display: October %M Month Arabic

ConvertExplicitly converts a data type expression to another data type. Because some requirements often use different date formats, the following can be found inFormat the date in SQL Server. SQL Server supports the data format in the Arabic style