Show datetime value into DD/MM/YYYY

By -

CONVERT(varchar(103),SUBMISSION_DATE,103) AS SUBMISSION_DATE

Comments

Post a Comment

Popular posts from this blog

DATA TABLE BIND WITH GRIDVIEW

By -
                                                  DATA TABLE BIND WITH GRIDVIEW DataTable TempTable = new DataTable();         TempTable.Columns.Add("Business_Place");         TempTable.Columns.Add("Within_State");         TempTable.Columns.Add("Outside_State");                DataRow dtrow;         dtrow = TempTable.NewRow();         dtrow["Business_Place"] = "Factories";         dtrow["Within_State"] = list[0].FACTORY_IN.ToString();      ...
Read more
By -
Image
Save and Retrieve Dynamic TextBox values in GridView to SQL Server Database In my previous article, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes. Now, seems that most of the developers are asking if how to save all the data that was entered from the dynamic textbox in the GridView to the database. So in this example, I’m going to show on how to save them all in the database. To get started then lets create a sample Table in SQL Server. In this example, I named the table as “SampleTable” with the following fields below: Note: I set the Id to auto increment so that the id will be automatically generated for every new added row in the table. To do this select the Column name “Id” and in the column properties set the “Identity Specification” to yes. Now let’s go ahead and proceed to ASPX source and add a Button for saving the data to the database. Take a look at the screen shot below: Now let’s ...
Read more

Difference between Byte and Char in Oracle

By -
If you define the field as VARCHAR2(11 BYTE), Oracle will allocate 11 bytes for storage, but you may not actually be able to store 11 characters in the field, because some of them take more than one byte to store, e.g. non-English characters. By defining the field as VARCHAR2(11 CHAR) you tell Oracle to allocate enough space to store 11 characters, no matter how many bytes it takes to store each one. I believe that in Oracle 10g, 3 bytes per character were used.
Read more