There is a field called `created` on a record. On ...
# suiteql
a
There is a field called
created
on a record. On the record it shows a date and time, but when I
Select created
from the record it only gives me the date. Am I doing something wrong? I want to order by created, but not just by date created but by time as well. Meaning it should get the most recent one
t
Hi @Azi. There are a couple of ways to have the time portion of the timestamp returned from the query.
One is: TO_CHAR ( CREATED, 'DS TS' )
Another: TO_CHAR ( CREATED, 'YYYY-MM-DD HHMISS' )
a
Thanks! Do I need to add those to the select to order by it?