|
View previous topic :: View next topic
|
| Author |
Message |
sree reddy
New User
Joined: 20 Jul 2007
Posts: 27
Location: bangalore
|
|
|
|
Could any one please send me query to get the NUMBER of days between 2 timstamps AND SUBTRACT SOME DAYS FROM THE DIFFERENCE
FOR EXAMPLE
select * From database.table
where date(End_ts)-date(current timestamp) - 50 days.
tHIS QUERY DID NOT WORK
Bye |
|
| Back to top |
|
 |
sree reddy
New User
Joined: 20 Jul 2007
Posts: 27
Location: bangalore
|
|
|
|
select * From database.table
where date(End_ts)<= date(current timestamp) - 50 days. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
| sree reddy wrote: |
select * From database.table
where date(End_ts)<= date(current timestamp) - 50 days. |
a little bit better for performance :
Select * from tab1
where End_ts <timestamp(current date,'00.00.00') - 49 days |
|
| Back to top |
|
|
|
|
