Query

[sandy1028]

Hi,

 

Please help me how to write the query to fetch the data from current timestamp to last 24hours from the table

[phat_hip_prog]

I'm supposing this is mysql, and that you have a timestamp (pref in some form of julian time (seconds)), then anything greater than now-(24*3600) is in last 24hrs

[ToonMariner]

assuming you store a time stamp then...

 

$qry = "SELECT * FROM `tablename` WHERE `timestamp` > " . time() - (3600 * 24);

$qry = mysql_query($qry);

 

if you actually store a date...

 

$qry = "SELECT * FROM `tablename` WHERE `date` > DATESUB(NOW(), INTERVAL 1 DAY)";

$qry = mysql_query($qry);

[sandy1028]

Hi,

 

Thanks for the reply...

I am storing timestamp values

select * FROM `net_performance` WHERE `timestamp` > " . now() - (3600 * 24)

 

I am confused whether it is time() or now().

Tell me which to use

[sandy1028]

When I use

select * from `tablename`  WHERE `timestamp` > " . now() - (3600 * 24);

 

all the values are displayed.

How to get the values only for 24 hrs