Ramu Prasad has Published 94 Answers

How to get last day of the next month in MySQL?

Ramu Prasad

Ramu Prasad

Updated on 29-Jan-2020 05:11:19

With the help of following MySQL query, we can get the last day of next month −mysql> SELECT LAST_DAY(now() + INTERVAL 1 MONTH) AS 'LAST DAY OF NEXT MONTH'; +------------------------+ | LAST DAY OF NEXT MONTH | +------------------------+ | 2017-11-30             | +------------------------+ 1 row ... Read More

What is the usage of ZEROFILL for INT datatype?

Ramu Prasad

Ramu Prasad

Updated on 28-Jan-2020 07:18:28

On specifying ZEROFILL for a numeric column, MYSQL automatically pads the displayed value of the field with zeros up to the display width specified in the column definition.For example, we create a table showzerofill and insert the values as follows −mysql> Create Table showzerofill(Val1 INT(5) ZEROFILL, Val2 INT(5)); Query OK, ... Read More

Importing data from Pgsql to SAP HANA database

Ramu Prasad

Ramu Prasad

Updated on 28-Jan-2020 05:24:36

Import and Export using a flat file is the easiest option. You can use CSV file if it is a onetime activity. However, If you think it is a repetitive activity then I would suggest you use HANA ETL options like HANA SLT replication, Smart Data access, etc.SAP HANA Replication ... Read More

List of Common Reasons for Segmentation Faults in C/C++

Ramu Prasad

Ramu Prasad

Updated on 27-Jan-2020 12:38:34

The main reason for segmentation fault is accessing memory that is either not initialized, out of bounds for your program or trying to modify string literals. These may cause a segmentation fault though it is not guaranteed that they will cause a segmentation fault. Here are some of the common ... Read More

How to create many Javascript variables in a single statement?

Ramu Prasad

Ramu Prasad

Updated on 17-Jan-2020 10:20:13

Declarations in a single line is a better way than creating many JavaScript variables in a single statement. It would be easier to add, remove and update variables with this.Let’s compare, var one = "Demo One!"; var two = "Demo Two"; var three = 5; var four = 30;Now, let’s ... Read More

What are events in JavaScript?

Ramu Prasad

Ramu Prasad

Updated on 17-Jan-2020 09:56:31

JavaScript's interaction with HTML is handled through events that occur when the user or the browser manipulates a page.When the page loads, it is called an event. When the user clicks a button, that click too is an event. Other examples include events like pressing any key, closing a window, ... Read More

How to create a zero-filled JavaScript array?

Ramu Prasad

Ramu Prasad

Updated on 13-Jan-2020 10:28:00

To create a zero-filled JavaScript array, use the Unit8Array typed array.ExampleYou can try to run the following code:Live Demo<html>    <body>       <script>          var arr1 = ["marketing", "technical", "finance", "sales"];          var arr2 = new Uint8Array(4);          document.write(arr1); ... Read More

How to concatenate several strings in JavaScript?

Ramu Prasad

Ramu Prasad

Updated on 09-Jan-2020 07:13:47

To concatenate several string, use “Array.join()” method. Here, we will concat the following strings:John Amit SachinExampleYou can try to run the following code to concat several stringsLive Demo<html>    <body>       <script>          var arr = ['Amit', 'John', 'Sachin'];          document.write(arr.join(', ')); ... Read More

Using clients in SAP ERP

Ramu Prasad

Ramu Prasad

Updated on 16-Dec-2019 09:58:35

Several independent companies or subsets of one company can be present in one SAP system. The client separates these companies and their relevant data. Client serves as a key to most of the SAP database tables and used customizing, transactional and master data. To summarise client serves as unique database key for ... Read More

Formatting date in SAP system

Ramu Prasad

Ramu Prasad

Updated on 16-Dec-2019 07:34:34

You will need to apply new culture to the existing thread as shown below:ExampleDateTime now = DateTime.Now; Console.WriteLine(now); CultureInfo sapCulture = new CultureInfo("en-US", true); sapCulture.DateTimeFormat.ShortDatePattern = "ddMMyyyy"; //sapCulture.DateTimeFormat.FullDateTimePattern =    sapCulture.DateTimeFormat.ShortDatePattern + " HH-mm-ss"; sapCulture.DateTimeFormat.LongTimePattern = "HH-mm-ss"; //sapCulture.DateTimeFormat.ShortTimePattern = "HH-mm-ss"; System.Threading.Thread.CurrentThread.CurrentCulture = sapCulture; //System.Threading.Thread.CurrentThread.CurrentUICulture = sapCulture; Console.WriteLine(now);Read More

Advertisements