Hi All,
I changed the date format from 2010.06.04 to 04 Jun 2010.
From that my query " select count(distinct(datetime))from trackeddata where datetime between (select timestamp'"+start+"') and (select timestamp'"+end+"') and unitid1='"+unit+"' ";" is not running.
Please help me.
thank you.