Advanced Search

Convert Date Field and Time field to DateTime

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. select
  2. evTitle as 'name',
  3. concat(description,"\n",url) as description,
  4. CASt(CONCAT(CAST(startDate as char),' ',cast(startTime as CHAR)) as datetime) as dtstart,
  5. CASt(CONCAT(CAST(endDate as char),' ',cast(endTime as CHAR)) as datetime) as dtend,
  6. evVenue as location,
  7. evAddress as street,
  8. evCity as city,
  9. evState as state,
  10. cast(NOW() as datetime) as modified_at,
  11. cast(dateEntered as datetime ) as created_at,
  12. '1' as author,
  13. '127.0.0.1' as author_ip
  14. from FTDevents;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.