Guest User

Untitled

a guest
Jan 20th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. Example
  2. timestamp
  3. 2012-09-25 00:00:00-->
  4. 2012-09-25 00:00:50
  5. 2012-09-25 00:01:23
  6. 2012-09-25 00:01:30-->
  7. 2012-09-25 00:02:33
  8. 2012-09-25 00:02:40
  9. 2012-09-25 00:03:01-->i want those
  10.  
  11. SELECT create_time
  12. FROM timeTable
  13. WHERE create_time
  14. IN (
  15.  
  16. SELECT min( create_time )
  17. FROM timeTable
  18. GROUP BY FROM_UNIXTIME( UNIX_TIMESTAMP( create_time ) - MOD( UNIX_TIMESTAMP( create_time ) , 60 ) );
  19.  
  20. SELECT create_time
  21. FROM timeTable
  22. WHERE create_time
  23. IN (
  24.  
  25. SELECT min( create_time )
  26. FROM timeTable
  27. GROUP BY DATE_FORMAT( `create_time` , 'Y-M-D %H:%i' )
  28. );
  29.  
  30. SET @time := '1000-01-01 00:00:00';
  31. SET @interval := 60;
  32.  
  33. SELECT colDate
  34. FROM table
  35. WHERE TIMESTAMPDIFF( SECOND, @time, colDate ) >= @interval
  36. AND @time := colDate
Add Comment
Please, Sign In to add comment