Shulou(Shulou.com)05/31 Report--

This article mainly explains the "what are the differences between sqlserver and oracle on datetime conditional query", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "what are the differences between sqlserver and oracle conditional query on datetime" bar!

First of all, take a look at sql server. Before, we used the front desk user to select a start time and an end time (in daily minimum units), and then to query as a condition. If we directly use "between starttime and endtime" as a condition, we find that "2009-06-17" will be automatically converted into "2009-06-17 00:00:00". So the following query condition: "between '2009-06-16' and '2009-06-17'", we can only get the data on the 16th, but not on the 17th. If we want to find the data on the 17th, we can process the time selected by the user: we can add detailed time conditions for it, such as "between '2009-06-16 000000between' and '2009-06-17 23,59and 59'" Or just skillfully replace the end time with the date of the next day, but this requires us to do some special treatment for the incremental date, because we may encounter the situation of choosing the last day of the month, which will not be discussed in detail here.

Let's talk about the processing in the oracle database, the same as the above two ways, but if we take a precise time approach, we need to deal with it through oracle's database time function, which is relatively tedious, and it may be more convenient if we increase the end date directly, of course, it can only adapt to the situation where the minimum unit of the selected date is "day". It is also important to note that the date string format adopted in oracle is different from that of sql server, generally in the form of "May-June-09", which requires us to do some intermediate conversion of the acquired time format, otherwise the statement will not be able to execute normally, of course, we can also deal with it through database functions, but it is relatively complex.

In fact, sometimes, for many problems, we can take a more formal approach, but if there are some implementation methods within the limited scope of the requirements that can fully meet the needs, I think it can still be used boldly, because the ultimate goal of our programming is to achieve the goal in the simplest way, and everything can not be too rigid. In fact, this process is also to improve our understanding of the needs of the project, and finally, we need to pay attention to some of the problems that we have to avoid, we must not be too careless.

Thank you for your reading, the above is the content of "what are the differences between sqlserver and oracle on datetime conditional query". After the study of this article, I believe you have a deeper understanding of the difference between sqlserver and oracle conditional query on datetime. The specific use also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.