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


  • 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?


  • Administrator
  • Hero Member
  • *****
  • Posts: 4691
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