Selecting a date with minus one!!

[Anon]

Hi!

I am trying to select some fields from my table with two conditions.
1.With the given sn and date as input.
2.so i should be getting the details of my query with one day minus to my given date.
This is my query in PHP3 ,for which i am getting error as Bad date external representation.

$result = pg_Exec($conn,
"SELECT sn,upstream,dstream,tdate FROM table where sn='$sn' and tdate='$date-1';");

so can anyone help me in sorting out the error in my query.
Thank Q
Sandhya

[kparker]

Do the date math on the column rather than the constant you are passing in, i.e:

"SELECT sn,upstream,dstream,tdate FROM table
where sn='$sn' and tdate + '1 day' ='$date';");

At least this concept works fine on 6.5.2 with a DATETIME column as 'tdate'. I don't have access at the moment to my 7.x systems, sorry.

[Anon]

Halo Parker!

Now, My query is working with ur valuable suggestion to me.Thank you once again.

Thank Q
Sandhya.