how to use conditional select query ? in sqlserver
- by Arunachalam
how to use conditional select query ?
in sqlserver
i have a column in which i store date type variable .now i should retrieve one value from that column and find the difference with the curent_timestamp and if the difference is less than 10 mins i should a return 1 and if more than 10 mins i should return 0.is it possible ?
05-12-2010 13.58.30 - 05-12-2010 13.56.30
here the difference is 2 so it should return 1 .