Hi,
I need data between two date from this “wp_cf7dbplugin_submits” table.Here is my query
SELECT
form_name,
DATE_FORMAT(FROM_UNIXTIME(submit_time), ‘%b %e, %Y ?%l:%i %p’) As Submitted,
max(if(field_name=’name’, field_value, null )) As ‘Name’,
max(if(field_name=’email’, field_value, null )) As ‘Email’,
max(if(field_name=’mobile’, field_value, null )) As ‘phone’,
max(if(field_name=’utm_medium’, field_value, null )) As ‘utm_medium’
FROM wp_cf7dbplugin_submits
WHERE
form_name = ‘Act Now’ and submit_time =’Mar 5, 2017 6:08 AM’
But because in table date are in raw format m not getting any result .Please help
-
This reply was modified 7 years, 8 months ago by geet1.