Skip to main content

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!

Hi there! The following should display CREATED_TIME() as a string in the format you want 🙂 


DATETIME_FORMAT(CREATED_TIME(), 'lll')

Woaw! That’s amazing! Do you know how could I just modify the PM and AM into pm and am please?

Woaw! That’s amazing! Do you know how could I just modify the PM and AM into pm and am please?


Hi @Inkoming


I found a link on the web with a list of date formats.




Hope it helps.

Mary K

That was exactly what I needed.

Thank you very much, my problem is now solved.

That was exactly what I needed.

Thank you very much, my problem is now solved.


Great! Glad to know @Inkoming.


Mary K

Reply


Terms & Conditions