use sql statement in Postgresql (time or date)

[gca07738]

database:postgresql 7.3
column:pdate , datatype: timestamp

two variable
$POST[start_date](ex:2003/02/01)

$_POST[end_date](ex:2003/05/24)

I try to use sql statement ,but it doesn't work.
Could anyone tell me how to use sql statement in Postgresql below


"select * from xxx where pdate >= $POST[start_date] and pdate <= $POST[end_date]"

[epp_b]

I don't really have any experience with PostgreSQL (I use MySQL), but it may actually be your POST variables

instead of [FONT=courier new]$POST[start_date][/FONT] try [FONT=courier new]$POST["start_date"][/FONT]