can odata url return timestamp value in human readable format

[prashanthi1]

Hello,

I have few fields in Oracle DB which are of timestamp datatype.

I have imported these tables and created views for these tables.

When I preview data the Date fields are getting displayed in a human readable format. eg -   2013-12-13 08:51:55.0

But when I create a VDB and access the odata URL, the Date fields are displayed in a the epoch format - 1437389047.

Please let me know if i can get them in human readable format when i access the Odata URL.

Thanks in advance,

Prashanthi.

[shawkins]

The expected format of an EDM DateTime is the milliseconds: http://www.odata.org/documentation/odata-version-2-0/json-format/

So the workaround to see a string form would be to add a view or modify the existing table to expose the timestamp column as a string type instead.

[prashanthi1]

Hi Steven,

Thanks for the reply.

On changing the datatype to String, i am getting an error - "The column 'CREATION_DATE' with runtime type 'string' does not match the runtime type 'timestamp' from the query transformation".

Thanks,

Prashanthi

[prashanthi1]

I had only changed the data type in view table. On changing in Source table also i am getting the expected output.

Thanks,

Prashanthi.

[shawkins]

You can also update the view select clause and cast to string - cast(timstampval as string)