Skip Navigation

[Resolved] Date Format timestamp export

This support ticket is created 7 years, 4 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 1 reply, has 2 voices.

Last updated by Luo Yang 7 years, 4 months ago.

Assisted by: Luo Yang.

Author
Posts
#454628

Hi there,
Date Format timestamp export

wpcf-geburtsdatum export from DB
-1461628800 <<<>>> 12.06.1925
-1680652800<<<>>>06.10.1916
-986428800 <<<>>>29.09.1938

with =(F2-DATUM(1970;1;1))*86400
i get
-1406073600 <<<>>> 12.06.1925
-1680048000 <<<>>>06.10.1916
-986428800 <<<>>>29.09.1938

so why is there a differenz. I am living in Germany /Hamburg an the server is working germany/ köln the same timezone.

Is this working after import?
thanks for help
Henryk

#454793

Dear Henryk,

Types stores timestamp value in the custom date field, about the Timestamp:
hidden link

you can use PHP function date() to display the formatted date value from Timestamp, for example:
$output = date( 'm.d.Y', $timestamp );

More help:
hidden link

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.