[mapserver-users] How to get data based on Date in Postgresql/PostGIS

thomas bonfort thomas.bonfort at gmail.com
Sun Dec 14 22:26:45 PST 2008


try
DATA the_geom from (select id,the_geom from pointlayer where
date='12/2/2008') as foo using unique id using srid=xxxx

--
thomas

On Mon, Dec 15, 2008 at 06:32, Venkat Rao Tammineni
<vtammineni at roulacglobal.com> wrote:
> Dear All,
>
>
>
>     I want get data based on Date. When  I run query  select * from
> PointLayer where news_date ='12/2/2008'; in postgre Query builder , it is
> working fine.
>
>
>
> When I try  "the_geom from PointLayer  where  news_date='12/2/2008'" I am
> not getting data(map).I don't know how to send  date parameter.is it
> possible ?if it is ..please let me know.
>
>
>
> Advanced thanks
>
>
>
> Venkat.
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>



More information about the MapServer-users mailing list