get time difference

Nov 27 2012 2:46 AM

i have a date field with type varchar. now i want to get time difference in days with today's date how can i get it?
actually i want to get rows which have day difference of more than 30 days.I have a field of lastlogin,i want to compare lastlogin with today's datetime and if the difference is more than 30 days we want to send those persons emails.

Answers (5)

Nesting Stored Procedures

how can compare two columns in different table