AnsweredAssumed Answered

REST Timestamp Post

Question asked by pfroelicher on Jul 3, 2018
Latest reply on Jul 5, 2018 by fmpdude


we are trying to POST a timestamp into a timestamp field through JSON and REST.

Our WINS2012 Server is in Brazilian Setting, and all our databases and computers are in the European Date convention of DD/MM/YY and not the US MM/DD/YY.


when we use Insert from URL and in the $data_json variable there is the string 'apontamentoTimeStamp in the variable

JSONSetElement ( "{}";

[ "uuid" ; RepApontamentos::uuid ; JSONString ] ;

[ "fk_funcionario" ; RepApontamentos::fk_id_func; JSONString];

[ "apontamentoTimestamp" ; RepApontamentos::rec_criado_timestamp; JSONString];

[ "AFD" ; RepApontamentos::RepAFD ; JSONString];

[ "localização" ;RepApontamentos::local ; JSONString]


The "apontamentoTimestamp leaves as 03/07/2018 18:00:00 and arrives as 07/03/2018 18:00:00.

any ideas?