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,
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.