Event start date

I am performing a function that will introduce events in the database.

The start date of the event is in the format 0000-00-00 00:00:00.

In table bx_events_main the field EventStart has the format 1433480400. How do I change 0000-00-00 00:00:00 to 1433480400?


thx

Quote · 11 Mar 2019

 

I am performing a function that will introduce events in the database.

The start date of the event is in the format 0000-00-00 00:00:00.

In table bx_events_main the field EventStart has the format 1433480400. How do I change 0000-00-00 00:00:00 to 1433480400?


thx

0000-00-00 00:00:00 is year, day, month, and time (or it could be yyyy,mm,dd; that isn't standard, depends on where you are in the world). The second one is the unix time stamp.

If the question is how do I code it to convert date to timestamp, then a quick internet search will give you lots of example.

Geeks, making the world a better place
Quote · 12 Mar 2019
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.