sql - mySQL query between two dates and two times -


I want to query a mySQL table to extract data between two dates and two times. I know how to do this for a "datetime" column using the "middle" column, but my columns are a "date" column and a "time" column.

From my range "Day 1" to 15:30 on day 1 + 1 day at 15:14

So far, I can get the following category (which works ): 

  Select time, intraday_values ​​close to WHERE date = "2005-03-01" and the time between "15:30" and "23:59"

But I have to explicitly include 2 dates and twice I have tried the following but get an error: 

  SELECT time, date = "2005- 03-02 "and between time =" 15:30 "and date =" 2005- intraday_values ​​close-to-03-02 "And time =" 15:14 "

Can someone help me in preparing questions correctly? Thank you very much

Not sure if your date field is indexed or not. If they are, then the "Concet" example others who have given them can not perform very well.

As an alternative, you can use a query in the form: 

 from  select * to foo where (date & gt; lo_ command and date & lt; upper_date ) - Technically, this section is not required if they are one day different or (date = bottom_date and time> gt; = bottom_time) or (date = upper-date and time & lt; = overtime_time)  < / Pre> 
 This is not beautiful, but it works and if they are in existence then the message to the date field is indexed Will allow you to use. 
 
 Your query 
 
 
  is SELECT time close to intraday_values, where (date & gt; "2005-03-01" and date is " 2005-03-02 ") or (date =" 2005-03-01 "and time> =" 15:30 ") or (date =" 2005-03-02 "and time

-

Comments

Post a Comment

Popular posts from this blog

sqlite3 - UPDATE a table from the SELECT of another one -

I have the first table article where some data is missing. In the table, articles_tmp I have a part of the missing data. So I want to update the articles. Where the path path is data in articles_tmp.path where the path is not zero . With SQLite , it does not work: update article SET path = (SELECT at.path FROM Articles_tmp as AS, WHERE at.article_id = a.id and a.asp, the text is in the form and not on. It has been transmitted) where the path is null MS Access Along with, it works fine: Update Articles Join the Inner Articles at articles_tmp articles.id = articles_tmp.id SETP articles.path = articles_tmp.path Can anyone help? Sin CE SQL Server Syntax, which I provided, was not working, here this solution With whom I have come. A little modification of your original query, but with my "correlation" suggestion added. There is a SQL Bella for this: Here is the code: update article SET path = (SELECT path from articles_tmp AS T WHERE t.id
Read more

c# - Showing a SelectedItem's Property -

So I have enabled a rightclick option for my DataGrid. I want to display the only chosen property but it is not behaving like what I would like it to display my name and additional. Public category Paymentinfo {public int PaymentNo {get; Set; } Public string date {get; Set; } Public Double Pay {get; Set; } Public Double Principle {get; Set; } Public Double Interest {get; Set; } Public Double Balance {Received; Set; }} Private Zero MenuItem_OnClick (Object Sender, RoutedEventArgs e) {MessageBox.Show (AmortGrid.SelectedItem.ToString ()); } I'm trying to apply it without using a View Module! If I place a breakpoint where the messagebox and the recipient place it on selected ITEM, then this property will display the payment. A date-payment-principle-interest-balance is the only value that needs payment. Was hoping that it would be something like this MessageBox.Show (AmortGrid.SelectedItem.PaymentNo.ToString ()); When you call ToString () So you get the class typ
Read more

javascript - Render HTML after each iteration in loop -

I'm trying to gradually increase the font size of text on a web page. The code works in my place, although the new HTML / CSS does not render after every iteration of the loop and when all this is done, then display only the text of 100 px size. To see the text as if it is slowly zooming, I need to do this JavaScript is down because it is being used from a different file here is what I have ... < Pre> & lt; P class = "game-title" style = "font-size: 50px" & gt; Test & lt; / P & gt; Function sleep (milliseconds) {var start = new date (). GetTime (); For (var i = 0; i & lt; 1e7; i ++) {if ((new date). GetTime () - start) & gt; Milliseconds {break; CSS ('font-size', 'parseInt ($ (' game-title '). CSS (' font-size ')) + 1 + "pixels"); } While (parasont ($ ('# text'). Css ('font-size')) & lt; = 100) {sleep (1000); IncreaseSize (); Using CSS: Use of jQuery (sample):
Read more