helpMySQL++ - Support: sr #2535, DateTime issue

 
 
Show feedback again

sr #2535: DateTime issue

Submitted by:  None
Submitted on:  Mon 26 Apr 2010 08:10:30 AM UTC  
 
Category: NonePriority: 5 - Normal
Severity: 3 - NormalStatus: None
Privacy: PublicAssigned to: None
Originator Email: -unavailable-Open/Closed: Open
Operating System: GNU/Linux

Add a New Comment (Rich MarkupRich Markup):
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Mon 26 Apr 2010 08:10:30 AM UTC, original submission:

Hello,

I have a very simple query that selects values of a time serie between two timestamps :

SELECT value FROM `data` WHERE stamp>='2010-04-26 07:00:00' AND stamp<'2010-04-27 07:00:00'

The results of this query are different with mysql++ and the client console. I have a two hours shift that corresponds to the diffenrence between UTC and local time (GMT+2). What is the problem ? What should I do to get the right results with mysql++ ?

Anonymous

 

(Note: upload size limit is set to 1024 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by None (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    No Changes Have Been Made to This Item
    Show feedback again

    Back to the top


    Powered by Savane 3.1-cleanup