mysql - SQL query to find rows between now and time in long -

-

i need run sql query find rows of data falls between particular interval of 1 hour, 1 day, 1 month , on. here time of hour or month passing in millis i.e long value of time duration below query

between (now() - interval " + timeduration + ") , now() - used pass time duration in string (1 hour) while using query , worked awesome

is of no me

can between query long time duration can 1 hour, 1 day , 1 week i.e. 3600000,86400000 , on

use timestampadd like;)

between timestampadd(hour, -1, now()) , now()

and day:

between timestampadd(day, -1, now()) , now()

Comments

Post a Comment

Popular posts from this blog

AbotX : How do you create a parallel crawler that stays on and can be added to at run time from new requests -

-
i have parallelcrawlerengine setup singleton , have alwaysonsitetocrawlprovider set singleton , passed parallelcrawlerengine. i can instantiate , leave nothing ok. can add site , crawl ok. if add site not crawl second site. i have looked @ example on site doesn't appear show how work , have new items added after initial execution. using .addsitestocrawl() adds them list seems stay in purgatory state of not being read. looking through logs 'site completed' message though site has not been recrawled [2016-07-11 11:17:18,361] [20 ] [info ] - crawl domain [http://www.existingsite.com/] completed in [0.0001118] seconds, crawled [361] pages and error if add new site [2016-07-11 11:17:33,365] [23 ] [error] - crawl domain [http://www.newsite.com/] failed after [0.0066498] seconds, crawled [361] pages [2016-07-11 11:17:33,365] [23 ] [error] - system.invalidoperationexception: cannot call dowork() after abortall() or dispose() have been called. @ abot.util.thre...
Read more

android - Create single AAR file from multiple modules using Gradle -

-
like many others, trying generate single aar file multi-modules android project. according this post , not supported android team because of various limitations (res & dependencies management, manifest merging, ...). i trying come own solution fits needs. know don't have duplicated resources , external dependencies (like support libraries) provided people using lib. my structure similar this: /root |- lib1 |- lib2 |- lib3 in order achieve goal, created 1 more library module, named distribute , include others modules. can share generated distribute.aar file. /root |- lib1 |- lib2 |- lib3 |- distribute this build.gradle file of distribute module: apply from: '../common.gradle' // configure properties shared accross modules apply plugin: 'com.android.library' def allmodules = rootproject.allprojects.collect { it.name } - [rootproject.name, name] def whitelabeldependencies = [ whitelabel1: allmodules - ['lib2'], whitel...
Read more

Android: SharingActionView on swipe from bottom -

-
Image
i share data other apps, don't want standard popup appears bottom tool bar; want kind of view: i followed official document: https://developer.android.com/training/sharing/shareaction.html so there native component in android sdk? or there library that? thank guys! you can : first create menu item : <menu xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" tools:context="com.example.rashish.myapplication.mainactivity"> <item android:id="@+id/action_share" android:orderincategory="100" android:title="@string/action_settings" android:icon="@android:drawable/ic_menu_share" app:showasaction="always" /> </menu> then create method show intent chooser dialog, : private void share() { string te...
Read more