Hi Daniel,
the Oracle datastore tests seem to confirm what Ian says, they create a table to store a date, a timestamp, and a time column (some databases
can handle the three types as separate) and the syntax is the following:
CREATE TABLE DATES (D DATE, DT TIMESTAMP, T TIMESTAMP)
and then they check the mappings work, overriding the test because Oracle has no notion of “time” alone:
/*
- Oracle has no concept of just “Time”. Sigh…
- @see org.geotools.jdbc.JDBCDateTest#testMappings()
*/
@Override
public void testMappings() throws Exception {
SimpleFeatureType ft = dataStore.getSchema(tname(“dates”));
assertEquals(Date.class, ft.getDescriptor(aname(“d”)).getType().getBinding());
assertEquals(Timestamp.class, ft.getDescriptor(aname(“dt”)).getType().getBinding());
assertEquals(Timestamp.class, ft.getDescriptor(aname(“t”)).getType().getBinding());
}
So yes, if you want GeoServer to handle date+time, use the TIMESTAMP column type.
···
Regards,
Andrea Aime
==
GeoServer Professional Services from the experts!
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions Group
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
https://www.geosolutionsgroup.com/
http://twitter.com/geosolutions_it
Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.
This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail