Hi all,

How to write a SQL Query to retrieve count of records each day(by getting sysdate from the system) for records inserted between yesterday night and today morning?

pls. advise

Thanks

providng you cna define what yesterday night and today morning is should be straightforward enough
have a look at the MySQL date/time functions
'all' you need to do is build the time banding appropriately

I just want a query like this

select count(*) from table where stamp between (today @ 6 a.m) and (yesterday @ 8 p.m) and I want to use the sysdate for getting today's date as this task will run everyday at some particular time

seems reasonable enough
so which verbs/functions/phrases do you think you need from the MySQL date/time functions

The below query will display yesterday's date and today's date using current date.

Use this in between the query u are using

select date_ADD(date_sub(CURDATE(), INTERVAL 1 DAY), INTERVAL 20 HOUR), date_ADD(CURDATE(), INTERVAL 6 HOUR)

rvijayee, thanks (sarcasm intended) for spoiling healdem's attempt to get merryba to learn how to figure it out for himself

welcome to dbforums and please do read the entire thread before jumping in again

Thanks rvijayee