Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 23, 2019 11:06 AM
Hi,
I’m using the created time field in my database when I receive a new messages that are stored in the database. Is there a way to modify it to display it right that?
Dec 23, 2019 8:23 pm
Thanks!
Dec 24, 2019 05:36 AM
Hi there! The following should display CREATED_TIME()
as a string in the format you want :slightly_smiling_face:
DATETIME_FORMAT(CREATED_TIME(), 'lll')
Dec 25, 2019 05:24 AM
Woaw! That’s amazing! Do you know how could I just modify the PM and AM into pm and am please?
Dec 25, 2019 06:03 AM
Dec 25, 2019 06:30 AM
That was exactly what I needed.
Thank you very much, my problem is now solved.