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 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.