Sign up ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

There is table in SLQ-Server 2008 R2. In this table i have date column with date format like this 2006-09-08 14:39:41.000. Now i make View from this table on Geoserver side but do nothing wiht date field. And make WMST layer. Now i go into Layer Preview and not see any features.
Okey i says. I take source table and publish it on geoserver but geoserver not see date column.
Whats wrong? In Geoserver docs i see that in WMST i gonna use ISO-8601 time format. How can i convert date format in view on Geoserver?


I make some tests.
I take Shape file with date field (i.e. 2002-08-20) put it into SQL-Server using ogr2ogr. SQL-Server says that my date field is date data type. Geoserver says it too. And in Layer Preview i see my features and after addin in address line TIME=2002-08-21 parameter i can see features with other dates.
After i add datetime field in my table and put into dates like 2002-08-20 Geoserver says that its Timeswap datatype. In Layer Preview i DONT GET any features addind TIME=2002-08-21T14.00.00.0Z not help. When i click on map i get error that cant convert varchar into datetime.

share|improve this question
Not sure but you need to convert few things. Please check following link… – Sunil May 13 '13 at 6:07
@Sunil: So you mean that i gonna have dates in seconds format like this 2312009? – Kliver Max May 14 '13 at 5:41
Yes. you need to convert and then check the result – Sunil May 14 '13 at 7:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.