I think if you would have done some easy research or gone through the available documentation, then you would have got the answer. The reason being you already know the partial answer (SQL example as you said).In SAP HANA database, we have an analogous table “SYS.M_TABLE_STATISTICS”. Just query the table for ... Read More

I think you better use the ParseExact method available over DateTime type. It should work.Please find the code snippet for reference −string dateFormat = "dd.mm.yyyy hh:mm:tt"; DateTime finalDate = DateTime.ParseExact(argumentDate, dateFormat, CultureInfo.InvariantCulture);

Use of escape character (\) would become very essential when we want to insert a comma or any other character between the values of a filed. It can be understood with the help of an example. Suppose we want to import the data from a text file named A.txt, having ... Read More

To convert text to uppercase with CSS, use the text-transform property with value uppercase.ExampleYou can try to run the following code to convert text to uppercase:                   Normal Text                Normal Text! This will be in uppercase!          

To set the scrolling of an image in the background, use the background-attachment property.ExampleYou can try to run the following code to learn how to work with the background-attachment property:                    body {             background-image: ... Read More

Associate styles with your HTML document using methods inline CSS and External CSS.You can use style attribute of any HTML element to define inline style rules. These rules will be applied to that element only. Here is the generic syntax:The following is the attribute:AttributeValueDescriptionstylestyle rulesThe value of style attribute is ... Read More

We can offload the time/date handling to MySQL with the help of DATE_FORMAT() function. The date and time would be offloaded on the basis of format units passed as arguments to the function.For example, when we pass the date format units as arguments to MySQL DATE_FORMAT() function then MySQL offloaded ... Read More

In this matter, MySQL permits us to use a relaxed format to date. We can use any punctuation character between date parts as a delimiter. Some examples are as follows −mysql> Select date ('2016/10/20'); +---------------------+ | date ('2016/10/20') | +---------------------+ | 2016-10-20          | +---------------------+ 1 row ... Read More

As the name suggests CURDATE() function will return the current date. In simple words, we can say that it would return only the date not time.mysql> select CURDATE(); +------------+ | CURDATE()  | +------------+ | 2017-10-28 | +------------+ 1 row in set (0.00 sec)In contrast, NOW() function will return current date ... Read More

Suppose we have a table ‘Order123’ having ProductName, Quantity and OrderDate columns as follows −mysql> Select * from Order123; +-------------+----------+------------+ | ProductName | Quantity | OrderDate  | +-------------+----------+------------+ | A           | 100      | 2017-05-25 | | B           | ... Read More