Convert timestamp to see seconds

[kktt]

When using the QueryService in AEP, I realized that the timestamp is only showing datetime format as "05/08/2023, 3:10 PM".

What would be the correct SQL to make the results show the seconds as well? ("05/08/2023, 3:10:54 PM") 

[Kumar_Saurabh_]

Hi @kktt,

Use the Command Line Interface to get the exact view of the data ingested in datalake.

https://experienceleague.adobe.com/en/docs/experience-platform/query/clients/psql

Regards,

Kumar Saurabh

[kktt]

Hi @Kumar_Saurabh_ - our company doesn't allow psql on our machines. Is there a sql query that I can use to directly convert the outputs in the query service UI? 

Thanks!

[Kumar_Saurabh_ · Accepted solution]

Hi @kktt,

Use the below query to get the complete timestamp in the Query Services UI:

select cast(column_name as string) from table_name;

Hope this helps!

Regards,

Kumar Saurabh