Although there is a meeting_date in daily_races, how can I lookup the meeting time?

Question

Is there an alternate site for this?

Answer 1

The field you need is scheduled_time in daily_races (also available in historic_races). This contains the race date and time in 'YYYY/MM/DD HH:MM::SS' format.

In MySQL, there is a DATE_FORMAT function that allows you to display any part of this field as you wish.

For example, the following query shows a number of ways to display this - play around with DATE_FORMAT to find the syntax that best suits:

>SELECT scheduled_time, DATE_FORMAT(scheduled_time, '%W %M %Y'), course, DATE_FORMAT(scheduled_time, '%H:%i') from daily_races where meeting_date=CURDATE();