Take the 2-minute tour ×
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?

UPDATE

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 14.00.00.000. 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 stackoverflow.com/questions/1509977/… –  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

 
discard

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

Browse other questions tagged or ask your own question.