Skip to main content

Created time modification

  • December 23, 2019
  • 5 replies
  • 32 views
I

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!

5 replies

A
Forum|alt.badge.img+19
  • AlliAlosa
  • Inspiring
  • December 24, 2019

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

DATETIME_FORMAT(CREATED_TIME(), 'lll')
I
  • Inkoming
  • Author
  • Participating Frequently
  • December 25, 2019

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

M
Forum|alt.badge.img+20
  • M_k
  • Inspiring
  • December 25, 2019

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

A
I
  • Inkoming
  • Author
  • Participating Frequently
  • December 25, 2019

That was exactly what I needed.
Thank you very much, my problem is now solved.

M
Forum|alt.badge.img+20
  • M_k
  • Inspiring
  • December 25, 2019

That was exactly what I needed.
Thank you very much, my problem is now solved.


Great! Glad to know @Inkoming.

Mary K

Terms & ConditionsAccessibility statement