Date vs datetime datatype: differences

lmattioli1 — Wed, 10 May 2017 20:02:28 GMT

After a bit of testing, I think I found that there's only one difference: in Share edit/visualization mode the datetime shows/asks for the time.In the DB the value is always stored as a datetime WITH a Timezone.Here's an example. I've three properties associated to the same node_id, the first is a d

Re: Date vs datetime datatype: differences

afaust — Mon, 15 May 2017 10:10:21 GMT

I am seriously confused - I believe we had this question first on IRC, then on this platform a couple of days ago or at the end of April and I responded to that, but it can no longer be found. I hope the one who created it did not delete it after getting the answer.

Yes, you do have to take care of the timezone in a CMIS query. The CMIS specification only defines support for datetime values - not date-only values - and the TIMESTAMP utiltiy for CMIS queries always includes a timezone identifier as part of the ISO 8601 notation.

Storing a LocalDate only makes sense if you store some accompanying information about where that local date is valid or hard-code your solution to a very specific place (like in your case Roma). Since Alfresco must support multi-national, multi-regional use cases it cannot do that, so it includes the timezone with a date.

Technically speaking Alfresco supports adding custom data types for properties, so e.g. a "d:localdate" (for very specific use cases where timezone really does not matter) could be implemented. Unfortunately the support for this in other parts of the application stack (e.g. SOLR for search) is insufficient to make this an easy endeavor.

topic Re: Date vs datetime datatype: differences in Alfresco Forum

Date vs datetime datatype: differences

Re: Date vs datetime datatype: differences