Custom Query question.

[former_member182305]

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.

[Former Member · Accepted solution]

Hi Sebastian ,

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

Thanks

Uday

[former_member182305 · Accepted solution]

Uday Chand Tli,

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

Regards.