List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:August 15 2008 1:50pm
Subject:RE: Need help to query with timestamp in C++
View as plain text  
I'm puzzled by the layout of your table, if that's what you're showing us. Is 
the timestamp in the table truly associated with the time at which the user 
put in his approximate time?

If, for example, the user types in 04:05:07 at 04:03:02, and then types in 
04:02:59 at 04:03:03, what is it that you want to return?

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-----Original Message-----
>From: Kandy Wong [mailto:kandyw@stripped]
>Sent: Friday, August 15, 2008 2:36 AM
>To: Saul Bejarano
>Cc: mysql@stripped
>Subject: Re: Need help to query with timestamp in C++
>
>Hi Saul,
>
>I need to use C++ and I'm not writing a web application.
>Thanks anyway.
>
>Kandy
>
>> I have done queries to the database in PHP with variables like month
>but
>> easily can select from a range of time and data to produce the same
>> results, the output goes directly to the web so if that is what you
>are
>> seeking for, I can help with PHP.
>>
>> Saul
>>
>> Kandy Wong wrote:
>>> Hi,
>>>
>>> I need to write a C++ program in a Linux environment to query with a
>>> timestamp.
>>> The user will only provide with an approximate time so I'd like to
>know
>>> how can I write a program or a query to return the closest data.
>>>
>>> The followings are the timestamp in the MySQL database:
>>> | 2008-08-05 03:56:09 | 1217933769 |
>>> | 2008-08-05 03:56:19 | 1217933779 |
>>> | 2008-08-05 03:56:29 | 1217933789 |
>>> | 2008-08-05 03:59:39 | 1217933979 |
>>> | 2008-08-05 03:59:49 | 1217933989 |
>>> | 2008-08-05 03:59:59 | 1217933999 |
>>> | 2008-08-05 04:02:39 | 1217934159 |
>>> | 2008-08-05 04:02:49 | 1217934169 |
>>> | 2008-08-05 04:02:59 | 1217934179 |
>>>
>>> For example, '2008-08-05 04:01:39' is the time provided by the user
>>> which
>>> does not exist in the database.  So, how can I return the closest
>data?
>>> I
>>> know I can make use of 'LIKE' but this will return more than one
>data.
>>> What is the best method to get the closest one?
>>> And what is the good connector (C++ to MySQL) to use?
>>> Any suggestion?
>>> Thank you.
>>>
>>> Kandy
>>>
>>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>
>--
>Kandy Wong
>Scientific Programmer Analyst
>TRIUMF (Canada's National Laboratory for Particle and Nuclear Physics)
>4004 Wesbrook Mall
>Vancouver, BC, Canada, V6T 2A3
>Phone: (604) 222- 1047 ext. 6193
>Email: kandyw@stripped
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>infoshop.com




Thread
Need help to query with timestamp in C++Kandy Wong15 Aug
  • Re: Need help to query with timestamp in C++Saul Bejarano15 Aug
    • Re: Need help to query with timestamp in C++Kandy Wong15 Aug
      • Re: Need help to query with timestamp in C++walter harms15 Aug
      • RE: Need help to query with timestamp in C++Jerry Schwartz15 Aug
  • Re: Need help to query with timestamp in C++DuĊĦan Pavlica15 Aug
    • Re: Need help to query with timestamp in C++Kandy Wong15 Aug
  • Re: Need help to query with timestamp in C++Warren Young15 Aug