Postgresql query

Discussion on SQL and MySQL
no avatar
chalamala.venkat
 
Posts: 1
Joined: Fri Jun 04, 2010 1:29 pm

Postgresql query

by chalamala.venkat » Fri Jun 04, 2010 1:34 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.

no avatar
tutorialspoint
Site Admin
 
Posts: 144
Joined: Fri Apr 27, 2007 6:52 pm

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

What problem you are getting, kindly give the detail.

Return to SQL and MySQL

cron