How to store and retrieve date in this format?

Asked

Viewed 14 times

0

What is the best way to store and retrieve date in this format, in MYSQL?

<news:publication_date>2019-02-19T18:57:26-03:00</news:publication_date>
  • You want it back by adjusting to timezone or disregarding?

  • I did a trick, I am converting to string and concatenating the dates with time, and putting the static zone, since it is always the same.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.