[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