Loading


Advertisement:

Author Topic: Custom date field SQL format  (Read 184 times)

gom555

  • Newbie
  • *
  • Posts: 9
Custom date field SQL format
« on: April 18, 2017, 01:16:26 am »
I can see that the date is stored in a strange numerical format in the database, eg. 1472857200.

I want to update this with a date in the format of yyyy-mm-dd. How can I convert this into the correct format for the database?

_CONEJO

  • Administrator
  • Hero Member
  • *****
  • Posts: 4668
Re: Custom date field SQL format
« Reply #1 on: April 18, 2017, 01:34:05 am »
That "strange" format is called timestamp. No need to change it as  it should later be correctly displayed