RE: Select a value between dates.

[George Law]

This brings up a question I was asked...

 

Which is more efficient?

 

Select ..... where date between 'yyyy-mm-dd hh:mm:ss' and 'yyyy-mm-dd
hh:mm:ss'

 

Or

 

Select ..... where unix_timestamp(date) between
unix_timestamp('yyyy-mm-dd hh:mm:ss') and unix_timestamp('yyyy-mm-dd
hh:mm:ss')