- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Prabhas has Published 78 Articles
Prabhas
334 Views
Your requirement is one of its kinds but can be achieved. What you can try out is first create a brand new object in the context. Let's say you provided the date as first input and 5 as a weekly slice in the second input. [Date+5]=DATEADD(@prompt('Slice', 'X'{'Day', 'Month', 'Year'}, mono, constrained, persistent), ... Read More
Prabhas
748 Views
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
Prabhas
143 Views
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);
Prabhas
282 Views
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
Prabhas
729 Views
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
Prabhas
261 Views
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
Prabhas
144 Views
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
Prabhas
39 Views
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
To Continue Learning Please Login
Login with Google