Following is a MySQL function which calculates the duration in years, months, days, hours, minutes and seconds between two dates.mysql> DROP FUNCTION IF EXISTS Duration; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> DROP FUNCTION IF EXISTS Label123; Query OK, 0 rows affected, 1 warning (0.00 sec) ... Read More

We can use 2-digit year value either in single date expression or in both date expressions used as argument/s in MySQL DATEDIFF() function.For example, the query below is using 2-digit year value in first date expression and other is having 4-digit year value.mysql> Select DATEDIFF('18-10-22', '2017-10-22'); +-----------------------------------+ | DATEDIFF('18-10-22', '2017-10-22') ... Read More

You can try to run the following code to validate the size of input type file:                                                             ... Read More

The rupee symbol is the following and not every browser supports it:₹To make it visible on your web page: You can use the following as well:₹

Suppose if we have stored a date value as ‘0000-00-00’ in MySQL table then on extracting year value from such kind of date, MySQL will return 0. It would not be in either Year(2) or Year(4) format. To understand it we are using the following data from ‘detail_bday’ table −mysql> ... Read More

Such kind of calculations can cause unpredictable result because when the date is represented as MySQL string then MySQL tries to perform numeric operations on a string by taking only the first that appears. Following examples will clarify it −mysql> select '2017-10-17' + 20; +-------------------+ | '2017-10-17' + 20 | ... Read More

All modern browsers support SVG and you can easily create it using JavaScript. Google Chrome and Firefox both support SVG.With JavaScript, create a blank SVG document object model (DOM). Using attributes, create a shape like a circle or a rectangle.var mySvg = "http://www.w3.org/2000/svg"; var myDoc = evt.target.ownerDocument; var myShape ... Read More

STEP 1: Create Standard Text. To create standard text, you have to use T-Code SO10.In next window, pass the Text Name -> Click on CREATE Push Button. This will open a new window where you can save the TEXT.Next step is to create the TRANSPORT REQUEST to transport the TEXT. This ... Read More

It is always recommended to back up your critical systems.ExampleFollowing SQL command can be used to export schema in HANA:EXPORT "SOURCE_SCHEMA_NAME".* AS BINARY INTO '/tmp/DESTINATION SCHEMA NAME' WITH    REPLACE;This can also be directly zipped to Linux as below:tar -czf SOURCE_SCHEMA.tgz /tmp/DESTINATION_SCHEMA/Read More

“ControlAggregation” refers to the target aggregation to which the mapped view is added.As Specified in the use case below:"routing": {    "config": {       "routerClass": "sap.m.routing.Router",       "viewType": "XML",       "viewPath": "sap.ui.demo.nav.view",       "controlId": "app",       "controlAggregation": "dummy",     ... Read More