1
Hello XOOPS
Im using a modified extcal module ..where i dont want to set time and i want to use only date for event....i would like to update my existing extcal database ...
so that event_start and event_end field of extcal module to have 00:00:00 time
as example from 2012-11-14
08:00:00 to 2012-11-14
00:00:00 the problem is in extcal event_start and event_end are originally in int format
SELECT `event_start`,`event_end` FROM `xxx_extcal_event`
i use this query to convert event start and event end to a readable date using this query
SELECT FROM_UNIXTIME(`event_start`),FROM_UNIXTIME(`event_end`) FROM `xxx_extcal_event`
i tried something like to update the time but its not working
UPDATE `xxx_extcal_event` SET FROM_UNIXTIME(`event_start`)=concat(FROM_UNIXTIME(`event_start`), ' 00:00:00'), FROM_UNIXTIME(`event_end`)=concat(FROM_UNIXTIME(`event_end`), ' 00:00:00')
after update event_start and event_end should be back in int format
how do i do this help.. im using phpmyadmin
