Advertisements

Postgresql query

Postby chalamala.venkat » Fri Jun 04, 2010 1:34 pm

Offline
chalamala.venkat
Posts: 1
Joined: Fri Jun 04, 2010 1:29 pm
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.

Postby tutorialspoint » Sat Jun 05, 2010 7:30 am

Offline
tutorialspoint
Site Admin
Posts: 143
Joined: Fri Apr 27, 2007 6:52 pm
What problem you are getting, kindly give the detail.