CMIS: Query: time specific attributes

CMIS supports following formats to query time related attributes.

Syntax

TIMESTAMP 'YYYY-MM-DDThh:mm:ss.SSS'

TIMESTAMP 'YYYY-MM-DDT+hh:mm'

TIMESTAMP 'YYYY-MM-DDT-hh:mm}'

Examples

SELECT * FROM cmis:document where cmis:creationDate >TIMESTAMP '2017-05-27T16:23:02.390+07:00'

SELECT * FROM cmis:document where cmis:creationDate <TIMESTAMP '2017-05-27T16:23:02.390-07:00'

SELECT * FROM cmis:document where cmis:creationDate >TIMESTAMP '2017-05-27T16:23:02'

Previous                                                 Next                                                 Home