To select date and format, use SELECT DATE_FORMAT(). Following is the syntax −Syntaxselect date_format(yourColumnName, '%e %b %y') from yourTableName;Let us first create a table −mysql> create table DemoTable    -> (    -> DueDate date    -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table ... Read More

To group rows in an array, use GROUP_CONCAT() along with the ORDER BY clause. Let us first create a table −mysql> create table DemoTable    -> (    -> Id int,    -> FirstName varchar(20)    -> ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table ... Read More

To get the HashCode for the current UInt32 instance, the code is as follows −Example Live Demousing System; public class Demo {    public static void Main() {       uint val1 = 100;       uint val2 = UInt16.MinValue;       Console.WriteLine("HashCode for val1 = "+val1.GetHashCode());   ... Read More

To get the angle whose sine is float value argument, the code is as follows −Exampleusing System; public class Demo {    public static void Main() {       float val1 = 0.1f;       float val2 = 8.9f;       Console.WriteLine("Angle (val1) = "+(MathF.Asin(val1)));     ... Read More

To get the hyperbolic arc-cosine of a floating-point value, the code is as follows −Exampleusing System; public class Demo {    public static void Main() {       float val1 = 0.1f;       float val2 = 0.9f;       Console.WriteLine("Angle (val1) = "+(MathF.Acosh(val1)));       ... Read More

To check whether the specified character has a surrogate code, the code is as follows −Example Live Demousing System; public class Demo {    public static void Main() {       string str = new String(new char[] { 'k', 'm', 'g', 't', '\uD800' });       bool res = ... Read More

To get synchronize access to the StringDictionary, the code is as follows −Example Live Demousing System; using System.Collections; using System.Collections.Specialized; public class Demo {    public static void Main(){       StringDictionary strDict = new StringDictionary ();       strDict.Add("A", "Books");       strDict.Add("B", "Electronics");       ... Read More

To get synchronize access to the StringCollection, the code is as follows −Example Live Demousing System; using System.Collections.Specialized; public class Demo {    public static void Main() {       StringCollection stringCol = new StringCollection();       String[] arr = new String[] { "100", "200", "300", "400", "500" }; ... Read More

To get the types nested within the current Type, the code is as follows −Example Live Demousing System; public class Demo {    public static void Main() {       Type type1 = typeof(Subject);       try {          Type[] type2 = type1.GetNestedTypes();       ... Read More

To get a specific type nested within the current Type, the code is as follows −Example Live Demousing System; public class Demo {    public static void Main() {       Type type1 = typeof(Subject);       try {          Type type2 = type1.GetNestedType("AdvSubject");     ... Read More