Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with SQL Query

Status
Not open for further replies.

umapathi72

Programmer
Jan 16, 2008
4
GB
Hi All Experts,
I found solution for my previous posts... thanks
here one more problem I am facing
the situation is ....
1). There is a field calld var_int = 60
in a query I have to check this field,
as x number of minutes without hardcoding the value

2). I have to select "X number of minutes from datetime_modified field", how to achive this ?

3). I have to check conditions for last time email sent period to datetime (EX: for every 100 minutes we have to send email, the datetime variable is stored like
'2007-10-20 10:30') From current time I have to compare this, how to achive this

Any help is greatly appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top