Thanks Jukka. It works. However I cannot change datetime pattern in the FTL. But it doesn't matter.
Regards S. M. Guru -----Original Message----- From: Rahkonen Jukka [mailto:[email protected]] Sent: Tuesday, 30 November 2010 6:44 PM To: Guru, Siddeswara (CMAR, Hobart); [email protected] Subject: Re: [Geoserver-users] oracle Date time in Geoserver Hi, What we do is to make a view into Oracle, select time with to_char in the format we like and publish it with Geoserver as a string attribute. I guess that with Geoserver 2.1 it would be possible to make a SQL query based layer instead of preparing a view. But views are handy and all you need to do is to create the view, add corresponding row into user_sdo_geom_metadata and grant select rights for the Geoserver user. -Jukka Rahkonen- Siddeswara.Guru wrote: > > Hello All, > I am publishing data from oracle database using Geoserver. > In the date field I get only date without time whereas the > database has stored both date and time as Date field. I know > that we need to use to_char function to get the Date to > required format in oracle. How do I use to_char in GeoServer > to select data from oracle in a datetime format. Any help in > this regard will be very helpful. > > Thanks. > > Regards > S.M.Guru > > -------------------------------------------------------------- > ---------------- > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! > Tap into the largest installed PC base & get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started > today with the > Intel(R) Software Partner Program. Five $500 cash prizes are > up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
