Revision: 12043
Updated Code
at February 28, 2009 16:22 by troynt
Updated Code
select evTitle as 'name', concat(description,"\n",url) as description, CASt(CONCAT(CAST(startDate as char),' ',cast(startTime as CHAR)) as datetime) as dtstart, CASt(CONCAT(CAST(endDate as char),' ',cast(endTime as CHAR)) as datetime) as dtend, evVenue as location, evAddress as street, evCity as city, evState as state, cast(NOW() as datetime) as modified_at, cast(dateEntered as datetime ) as created_at, '1' as author, '127.0.0.1' as author_ip from FTDevents;
Revision: 12042
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at February 28, 2009 16:21 by troynt
Initial Code
INSERT INTO wp_ce_events ( name, descwp_ce_eventsftrnorg_ftdayription, dtstart, dtend,location,street,city,state,modified_at,created_at,author,author_ip ) select evTitle as 'name', concat(description,"\n",url) as description, CASt(CONCAT(CAST(startDate as char),' ',cast(startTime as CHAR)) as datetime) as dtstart, CASt(CONCAT(CAST(endDate as char),' ',cast(endTime as CHAR)) as datetime) as dtend, evVenue as location, evAddress as street, evCity as city, evState as state, cast(NOW() as datetime) as modified_at, cast(dateEntered as datetime ) as created_at, '1' as author, '127.0.0.1' as author_ip from FTDevents;
Initial URL
Initial Description
Initial Title
Convert Date Field and Time field to DateTime
Initial Tags
Initial Language
MySQL