Question Re: Custom Query question. in Spend Management Q&A

Custom Query question.

former_member182305 — Mon, 28 Oct 2013 20:56:28 GMT

Hello Experts,

We need to develop a query and one of the filds that is required is the date and time that a MA was created. We were searching the information in the table FCI_CONTRACT, the name of the field is CREATED_AT.

That field in that table contains the Date but not the time and in the field where the information is displayed it appears the time. Is there a way to include in the query that time at what the document was created?

Thank you for your answers.

Best Regards.

Re: Custom Query question.

Former Member — Tue, 29 Oct 2013 07:48:52 GMT

Hi Sebastian ,

Change the column data type to Date Time in Query and you shall see time in the results.

Thanks

Uday

Re: Custom Query question.

former_member182305 — Tue, 29 Oct 2013 15:16:00 GMT

Uday Chand Tli,

Thank you very much for your answer. We did that in the query and it worked.

Regards.